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: 5,939
Default Print Causes Sheet Performace to Drop

I am working on a spreadsheet that I inherited and I am having a problem. One
of the sheets performs fine until I do anything to print the sheet or to
modify any of the print settings. After that the sheet performance drops off
and any actions slow down to a crawl (even just scrolling up an down is
painfully slow). It only effects this one sheet and all other sheets perform
fine. The only way to fix the sheet is to close the spreadsheet and then
reopen it. It will once again work fine until I do anything associated with
the print functionallity. Before I go ahead and delete and re-create the
sheet (a task I am not looking forward to as it is full of named ranges and
such) I was wondering if anyone else has seen and rectified this problem. I
suspect that somehow the sheet has become corrupted in some way but I was
hoping someone else might have some guidance here.

As an aside it intermitenetly had the bizzare side effect of spontaneously
turning on Chip Pearson's RowLiner Addin when the print functionallity was
accessed. I completely removed the addin from my system but I am still having
the problem.
--
HTH...

Jim Thomlinson
 
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
Does installing Service Packs help with Excel performace? Beeatrice Excel Discussion (Misc queries) 3 October 29th 09 04:22 PM
print and print preview not active in file drop down Bjorne Excel Discussion (Misc queries) 2 March 21st 06 06:36 AM
Need Macro to print a sheet conatining drop down menu Faizal Excel Programming 1 April 29th 05 04:06 PM
NormInv performace in Excel 2003 webshark Excel Programming 3 March 29th 05 01:32 PM


All times are GMT +1. The time now is 07:26 AM.

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

About Us

"It's about Microsoft Excel"