Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't stop Excel re-calculating on opening - hmmm...
Hello all - have searched the boards to death but I'm still getting thi issue - help massively appreciated :) I have a large "calculations" spreadsheet which needs to open some CS files. I have the code sorted to do all that, e.g. Application.Calculation = xlCalculationManual then I do this code just to open a file - it's a CSV file which open directly: Workbooks.Open Filename:= _ "L:\FTP_ROOT\RISK_TST\Reports\rpt_013_liabilities. c sv" then the code goes on to do some calcs and so on... There are about 5 sheets to open and then later close. THE PROBLEM: Excel calculates the WHOLE CALCULATIONS spreadsheet when open the CSV file, even though calculation is off. I can only assum this is part of the way that I've opened the file. :-S Please help - it takes Soooooo long to recalculate the entir spreadsheet now and what I do with the rest of the very long macro i to make it calculate only the sections it needs - i range("x").calculate or sheets("y").calculate and so on. This bit work fine though. So - how do I make a CSV file open -without- recalculating? Thanks so much for your help : -- gearo ----------------------------------------------------------------------- gearoi's Profile: http://www.excelforum.com/member.php...fo&userid=2657 View this thread: http://www.excelforum.com/showthread.php?threadid=39907 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't stop Excel re-calculating on opening - hmmm...
g,
Take a look at what Charles Williams has to say... http://www.decisionmodels.com/calcsecretse.htm Jim Cone San Francisco, USA "gearoi" wrote in message Hello all - have searched the boards to death but I'm still getting this issue - help massively appreciated :) I have a large "calculations" spreadsheet which needs to open some CSV files. I have the code sorted to do all that, e.g. Application.Calculation = xlCalculationManual then I do this code just to open a file - it's a CSV file which opens directly: Workbooks.Open Filename:= _ "L:\FTP_ROOT\RISK_TST\Reports\rpt_013_liabilities. c sv" then the code goes on to do some calcs and so on... There are about 5 sheets to open and then later close. THE PROBLEM: Excel calculates the WHOLE CALCULATIONS spreadsheet when I open the CSV file, even though calculation is off. I can only assume this is part of the way that I've opened the file. :-S Please help - it takes Soooooo long to recalculate the entire spreadsheet now and what I do with the rest of the very long macro is to make it calculate only the sections it needs - ie range("x").calculate or sheets("y").calculate and so on. This bit works fine though. So - how do I make a CSV file open -without- recalculating? Thanks so much for your help :) -- gearoi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
want excel 2007 to stop calculating processors | Excel Discussion (Misc queries) | |||
How do I stop Excel opening up my PDF documents | Excel Discussion (Misc queries) | |||
Need to stop personal.xls from opening with every Excel doc? | Excel Discussion (Misc queries) | |||
How do I stop IE opening excel workbooks ? | Excel Discussion (Misc queries) | |||
Calculating Cells causes Excel to stop responding | Excel Discussion (Misc queries) |