 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2006External Data Source Change
I set up an external data source to update a weekly report. However, the number of lines in one of the sources can fluctuate weekly. This week, that source had more lines, and as a result my refresh did not bring in all of this weeks data. How can I fix the data source to to pull in all the lines of data. We would need to see more specifics on exactly how you are retrieving the external data. Vaya con Dios, Chuck, CABGx3 > I set up an external data source to update a weekly report. However, > the number of lines in one of the sources can fluctuate weekly. This > week, that source had more lines, and as a result my refresh did not > bring in all of this weeks data. How can I fix the data source to to > pull in all the lines of data. Chuck, Thanks for looking at this. I got an answer this am, in my office. I set up my db's using the Import External Data function in excel --> New Database Query. Realizing that I needed to re-define my db, I was trying to highlight the current week's lines of data, and then re-name in the Name Box. This seemed to simply serve as a "go to" function. What works is selecting the current data range and then renaming using the Insert --> Name --> Define function. > We would need to see more specifics on exactly how you are retrieving the > external data. [quoted text clipped - 7 lines] > > bring in all of this weeks data. How can I fix the data source to to > > pull in all the lines of data. Glad you got it working Don.........thanks for the feedback. Vaya con Dios, Chuck, CABGx3 > Chuck, > Thanks for looking at this. I got an answer this am, in my office. I [quoted text clipped - 16 lines] > > > bring in all of this weeks data. How can I fix the data source to to > > > pull in all the lines of data.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.