Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I don't get it... I've created the macro in a copy spreadsheet. Once it was
working I copied it to the template (a read only version). That's where the slowing down problems began.. I went back to the copy spreadsheet and it is working fast as it is supposed to be... The error was because of a typo in calcualtions... Still not changing the speed... Any ideas? "gaba" wrote: Thanks for your answer, Jim. It is giving me an error... I'm retracing what I added at the end and it is making it so slow. Soon as I find what's wrong I'll post it Thanks a lot, Gaba "Jim Thomlinson" wrote: Tyr turning the calculation off at the start and back on at the end. Application.calcualtion = xlManual ... Application.calculation = xlAutomatic Whenever you toggle these appliation settings it is a good Idea to impliment an error handler to reset thme in case of a problem. Hope this works... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel super slow on paste function in 2007 | Excel Discussion (Misc queries) | |||
File running slow! | Excel Discussion (Misc queries) | |||
Super slow table array formulas | Excel Worksheet Functions | |||
Excel super slow start, answers? | Excel Discussion (Misc queries) | |||
Worksheet Running Very Slow | Excel Worksheet Functions |