Experiencing slow response time with simple macros

snoopy83

New Member
Joined
Oct 3, 2006
Messages
1
I am having trouble working in with a file because it takes a couple minutes to open/save and any edits to VBA coding taking up to a minute just to type and be recognized. Sometimes simple cell entries in excel cause lag. I'm running on a dell latitutde with 1.86 GHz, 504MB RAM.

The file is written in Excel 97 and is <2MB. I have been trying to work in the VBA coding with my default excel, 2002, but come across siginificant lag writing/running macros. I have now installed 2000, only to have simliar issues with lag. The file must remain in 97 since the end user will be operating 97. Do I have to intall 97 in order to easily work with the file?

Also, for my own curosity, what is causing this lag? I have disabled macros, set calculation to manual, and saved the file, yet it still takes a couple minutes. The macros are very simple, mostly hiding and unhiding rows/columns/worksheets. The file does have many "defined" cells, (e.g. 'InputName' etc.). Does this add the hang up?

Thank you in advance for your help.
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
This link has some code that may help.
http://www.mrexcel.com/board2/viewtopic.php?t=205061
Also, some suggestions to keep file size down and reduce workbook slow-down.
Avoid the following:
Formats that extend over entire Columns, (65536 rows) or entire Rows, (256 columns).
Graphics, even if they are hidden.
Formulae that reference entire rows or columns.
Named ranges that are referenced from worksheets other than their own.
 

Forum statistics

Threads
1,141,915
Messages
5,709,320
Members
421,628
Latest member
Big Boss

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top