Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Boston2AZ
 
Posts: n/a
Default One page is SO slow; I recreated, no help; what is wrong?

I cannot cut and paste info or add/delete rows; when I try, it's either
incredibly slow or it knocks the program offline and I have to close the "not
responding" program. I recreated the page, eliminated other worksheets in the
spreadsheet- no luck. I use color but no formulas, etc. Is there something
that I can do to fix this? It's the ONE spreadsheet that I need every day -
of course!! Thanks!
  #2   Report Post  
Michael
 
Posts: n/a
Default

Hi
Have a look at the size of your spreadsheet by doing a CTRL+End.
If it takes you a location way outside your working range, delete the excess
rows and columns and see if that helps.
Also, if you are running Macros that have huge ranges that are not being
used, it will also slow things down.

HTH
Michael

"Boston2AZ" wrote:

I cannot cut and paste info or add/delete rows; when I try, it's either
incredibly slow or it knocks the program offline and I have to close the "not
responding" program. I recreated the page, eliminated other worksheets in the
spreadsheet- no luck. I use color but no formulas, etc. Is there something
that I can do to fix this? It's the ONE spreadsheet that I need every day -
of course!! Thanks!

Reply
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
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 09:29 AM
print selected sections on the same page ripley Excel Discussion (Misc queries) 1 February 22nd 05 04:04 PM
How do I keep page breaks for each page in a sheet without the co. notexcellent Excel Discussion (Misc queries) 0 February 9th 05 07:53 PM
slow page break previews chriscrisco Excel Discussion (Misc queries) 1 December 13th 04 08:06 PM
excel 2003 page numbering art Excel Worksheet Functions 3 December 8th 04 10:49 PM


All times are GMT +1. The time now is 01:14 AM.

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"