LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Recalculation

I'm using Office/Excel 2003, Windows XP.

I have a spreadsheet that has a macro to open a bunch of files and move
them into the spreadsheet with the macro.

My problem is that after I move a sheet it recalculates and this takes
quite a time and I'm moving several sheets.

I've tried to start the macro with manual calc, and then run, changed
personal.xls to manual calc and even inserted code to change to manual
calc but it still persist in recalcing after moving each spreadsheet
into the "master".

I think the issue is related to the files I'm moving into my master
being csv as I don't have the same problem if they are .xls

Thanks in advance
Mike

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Recalculation? Mike D. Excel Discussion (Misc queries) 8 July 13th 07 04:33 AM
recalculation shmilo Excel Discussion (Misc queries) 1 February 13th 07 02:40 PM
Recalculation R Ormerod Excel Discussion (Misc queries) 5 March 19th 06 08:54 AM
Too much recalculation Diane Meade[_2_] Excel Programming 2 May 26th 04 07:19 PM
Recalculation Anna[_6_] Excel Programming 1 May 24th 04 11:15 PM


All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"