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: 76
Default Slow to add or delete sheet

Hello All

I have a 13mb excel file with about 30 sheets on it. Calculation and
Screenrefreshing are turn off. It takes about 3 minutes to delete or add a
sheet.
Inserting/deleting a row also has the same effect.

Can anybody help or point me in the right direction to try and speed this
activiity up.

Thanks
 
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
Excel 2007 extremely slow to delete cells coffent Excel Discussion (Misc queries) 1 October 1st 09 04:42 AM
Very slow when I delete Row...how to speed up? leungkong Excel Programming 10 December 8th 08 06:55 AM
Slow Delete Blank Rows Macro Monk[_2_] Excel Programming 5 March 31st 08 02:12 AM
Using SpecialCells().EntireRow.Delete on large worksheet - Very slow! Ilan[_2_] Excel Programming 6 September 15th 04 12:09 PM
Slow enter on sheet steve Excel Programming 3 October 7th 03 12:26 AM


All times are GMT +1. The time now is 11:32 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"