Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Slowing Macro
Dan
I can't think of what might cause that, but post the code and maybe something will jump out. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Dan" wrote in message ... I have a macro that pulls data from the internet every 15 minutes or so. The more I run the macro, the slower it goes. There seems to be a cumulative slowing effect like something is building up and slowing it down. It is still as slow after I shut down and reboot as the last time I ran it and it continues to get even slower yet. Any suggestions would be greatly appreciated. Thank you in advance if you have any ideas how to fix this. Thanks, Dan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Slowing Macro
Dan,
Look at your defined names and see if you have names like Tablexxx I had a problem with this when downloading from the net. There were hundreds built up over time. Got rid of them and life was better. Built an event macro to delete all names Like Table* and solved the problem. steve "Dick Kusleika" wrote in message ... Dan I can't think of what might cause that, but post the code and maybe something will jump out. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Dan" wrote in message ... I have a macro that pulls data from the internet every 15 minutes or so. The more I run the macro, the slower it goes. There seems to be a cumulative slowing effect like something is building up and slowing it down. It is still as slow after I shut down and reboot as the last time I ran it and it continues to get even slower yet. Any suggestions would be greatly appreciated. Thank you in advance if you have any ideas how to fix this. Thanks, Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked cells slowing me down? | Excel Discussion (Misc queries) | |||
Excel slowing down during usage | Excel Discussion (Misc queries) | |||
slowing down | Excel Discussion (Misc queries) | |||
My macros are slowing down. | Excel Programming | |||
My macros are slowing down. | Excel Programming |