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.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,059
Messages
5,545,758
Members
410,704
Latest member
Cobber2008
Top