Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Spreadsheet Link error Excel '97
I am retrieving data from a server (the system is called Cartesis) to an
excel spreadsheet. The Cartesis add-in handles the retrieving of the data, and all I have to do is type in a VBA command to update the Cartesis information on a spreadsheet. The macro I am running requires about 200 reports to be run one after the other (ie. 200 spreadsheet refreshes). This should take about 5 hrs on my machine. After about 3 hours of running, the macro crashes with the following error : "Dynamic Spreadsheet Link - too much data has been loaded. The server will close as it could become unstable." If anyone has heard of this error or knows how to correct it, please let me know. Maybe it has something to do with DDE Regards Mike *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is a dynamic/live link INTO Access FROM Excel possible? | Excel Discussion (Misc queries) | |||
How to link a dynamic image in excel | Links and Linking in Excel | |||
can you link outlook to an excel spreadsheet?? How!! | Excel Discussion (Misc queries) | |||
Excel Program Link Error? | Excel Discussion (Misc queries) | |||
LINK EXCEL INVOICE TO A SPREADSHEET | Links and Linking in Excel |