Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
External Datasource Problem.
I've got an interesting problem. We're running excel
2002, and have several external data ranges to Sqlserver tables. On occassion, the ranges become hard coded values. Nothing different is done and we don't notice it until we start looking at the data and realize the data has not been refreshed. We'll go weeks without a problem and then have it pop up. Our workbook has approximately 10 external ranges, each on its own sheet. This happens randomly among the sheets, and only affects a single sheet, all other ranges remain refreshable. Has anyone come accross this problem or seen something similar? Thanks Tom. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
External Datasource Problem.
are you running any macros in this workbook. It could be that a macro has
an unqualified reference and hits the activesheet when it runs. -- Regards, Tom Ogilvy "Tom" wrote in message ... I've got an interesting problem. We're running excel 2002, and have several external data ranges to Sqlserver tables. On occassion, the ranges become hard coded values. Nothing different is done and we don't notice it until we start looking at the data and realize the data has not been refreshed. We'll go weeks without a problem and then have it pop up. Our workbook has approximately 10 external ranges, each on its own sheet. This happens randomly among the sheets, and only affects a single sheet, all other ranges remain refreshable. Has anyone come accross this problem or seen something similar? Thanks Tom. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Link Problem | Excel Discussion (Misc queries) | |||
Pivot Table from External Datasource of Excel Workbook | New Users to Excel | |||
How to refer to external datasource in Excel domain aggregate func | Excel Worksheet Functions | |||
External data query leaves datasource workbook open | Excel Discussion (Misc queries) | |||
Lookup in data from external datasource | Excel Worksheet Functions |