Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Slow calculation
I have a spreadsheet with calculations in 22 columns in 6
sheets, that imports an external data file each day. In an effort to save time, I've added code that pastes formulas as values in the pertinent day's column each day so the calculation process will not be as slow. The last 13 columns I have pasted as values after the first day is imported because the data is 13 weeks of history and will not change. I just wondered if there was any better way to do this. Thanks as always for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow Calculation | Excel Discussion (Misc queries) | |||
worksheet very slow in calculation | New Users to Excel | |||
Slow Calculation | Excel Worksheet Functions | |||
Slow Calculation speeds in big spreadsheet | Excel Worksheet Functions | |||
Does this slow down calculation? | Excel Discussion (Misc queries) |