Excel is SLOW when using Save, Paste, Bold or Copy.

[ebin charles]

Hey!

I am working man hours calculation in excel which comes around
8500 rows and 250 columns in a sheet.
When I try to run a macro or any function (as Save, Paste, Bold or Copy) it
is dead slow and takes an hour for whatever functions.

I have Dell optiplex 790, i3-2.42 with 4 GB RAM with good speed.
I have Macro settings to "Enable all macros (not recommended...... and Truste all VBA project model...

Please some genius help me what is the problem or any settings I need to change or any mistake I am doing...?

below is my macro:

Please Login or Register  to view this content.

Regards,
Charles P

[smuzoen]

When I try to run a macro or any function (as Save, Paste, Bold or Copy) it is dead slow and takes an hour for whatever functions.

So the problem is not just running the macro's? Does the page have a lot of formulas especially array formulas. If you hit Ctrl ` (under the tilde key) it will show all your formulas in the sheet. Try turning off automatic calculation of the sheet and make it manual and see if it makes a difference.

Hope this helps.
Anthony
“Confidence never comes from having all the answers; it comes from being open to all the questions.”
PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated”