LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rozonus
 
Posts: n/a
Default Removing Page Break Preview from all spreadsheets

Hi all...
(This problem suddenly, randomly started happening to a customers laptop
after they came back from a business trip abroad)
I have been having trouble with Page Break Preview for a while now on a
customers laptop. Alot of the customers Excel work is taking a long time to
open and close, and takes longer to respond again if data is changed or saved.

Well, I finally found out that these spreadsheets all had Page Break Preview
turned on. Excel must have a crazy bug with the printer drivers, because it
appears to be causing the page breaks ages to re-calculate the preview if
something is changed (apparently it relies on the printer drivers to display
the preview, according to a google search). If I turn Page Break Preview off,
the spreadsheets become fine again.

Anyhoo, there are alot of Excel files with Page Break Preview turned on, and
many of these have multiple sheets with it on too. To make any of these easy
to use again, I have to open it, set it to Normal, save it, close it and open
it again. Every time I do this, I have to wait while it pauses between each
step. It would take me (or my customer) ages to go through every spreadsheet
and change the view to normal.

Is there a way I can set Excel to open every spreadsheet in Normal view? I
know this doesn't fix the random problem why Page Break Preview suddenly made
all the sheets slow, but it is a start.

Any help is greatly appreciated.
 
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 page break preview RK Excel Discussion (Misc queries) 3 February 17th 05 12:33 AM
Page Break Preview dwbrit Excel Worksheet Functions 0 February 7th 05 11:07 PM
PAGE BREAK PREVIEW Melvin Excel Discussion (Misc queries) 1 December 27th 04 07:17 AM
page break preview lein Excel Discussion (Misc queries) 0 December 23rd 04 10:55 AM
slow page break previews chriscrisco Excel Discussion (Misc queries) 1 December 13th 04 08:06 PM


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