page break preview errors
Steve
Forthe past few months, my xl2007 has been "freaking out" with regards to
the page break preview.
I.e., I'll be working on a worksheet, and without warning the page break
preview will go from my standard setting to where there are page breaks for
every single cell in my worsheet. E.g. say that I've got a page that's 7
columns wide, and 50 rows. There will be 350 pages of "page breaks", each-
one column by one row-- every single cell.
At first it was easily resolveable, albeit inconvenient. I'd simply,
manually move the page breaks and after a few moments it'd go back to normal.
However, with increasing frequency it's gotten worse, and almost impossible
to reset the page breaks any more.
Yesterday I'd just finished working on a file and closed it. After a couple
of minutes I'd realized that I forgot to perform a task, and reopened it to
complete that task. Upon opening, all of my pages in the file were set at a
single cell page break.
No matter what I did-- and after months of this I'd learned quite a few
tricks-- nothing worked. I'd follow the warning instructions of turning off
page break preview, setting to normal, wiping out the page breaks, trying to
go into page set up, etc..... nothing worked.
I have no macros that set the pagebreak previews.
It "just happens."
Oh, and only sometimes does closing the file, and reopening it help.
Yesterday my system got so overwhelmed with it, that it seized, and I had to
force quit with ctrl+alt+del-end task. When it did come back up, all was
returned back to normal, and it had two recovery files that I summarily
tossed because they were the corrupted ones.
At this point, it's gotten frequent enough, and tedious enough that I need
to find a fix for this, and to prevent it from continuing to occur. Forget
frustrating.... it's beyond that.
I can find no rhyme or reason, no sense to how or why it'd happen.
So, I guess my questions are:
1- has anyone else had this happen?
2-If so, did you ever get it to stop?
3- if you did get it to stop, how?
4- if it's still occurring, what are the work arounds you're implementing to
reduce, or minimize its impacts on your work?
Your helps are deeply appreciated.
Best.
Steve
macropod
Are you sure the page setup is correctly defined? Changing the page layout by dragging the margins only changes the print scale.
Is your copy of Excel fully updated?
Have you tried repairing Excel (Excel Options|Resources|Diagnose)?
--
Cheers
macropod
[Microsoft MVP - Word]
"Steve" <St...@discussions.microsoft.com> wrote in message news:30196035-94B3-4759...@microsoft.com...
Steve
Correctly defined. Please elaborate on what you mean by that.
As to excel being fully updated. Yes.
As to repair- I hadn't thought of that, and just finished it a few minutes
ago, already rebooted.
macropod
> Correctly defined. Please elaborate on what you mean by that.
As in correct paper size, margins, etc.
--
Cheers
macropod
[Microsoft MVP - Word]
"Steve" <St...@discussions.microsoft.com> wrote in message news:D3F01F13-7D1C-4457...@microsoft.com...
Steve
Yes, the sizes, margins, etc... have all been correctly set.
As stated, this is something that just happens, with no present rhyme or
reason.
Then, it just happened again a few minutes ago.
So, to clarify further.
The page size is legal. The margins are 0.25 for left and right, 1.25 for
top, and 0.5 for bottom. The header is 0.25, and the footer is also 0.25--
all inches.
The orientation is portrait, and the data normally fits on 1 to 10 pages. In
the case of this specific file that it happened to this morning, it fit on
1/2 the page just fine and had never caused this problem before.
I then have it set to print 1 page wide, and as many pages are required for
length. I.e., I leave the length space blank, because I'd found it worked
before, and never gave me any trouble.
Again, thank you for your time.
"macropod" wrote:
> .
>
Steve
individual celled page breaks is to do the vertical-horizontal alignment on
two columns outside the print area.
"macropod" wrote:
> .
>
Steve
This issue is still unresolved.
In speaking with a few diffrent people, this appears to be a common issue--
i.e., I am not the only one it's happening to.
Some of my attempted fixes have been--
1- set my default printer to the xps printer. No solution.
2- close and restart the entire excel program, without saving the work done.
A partial solution. It can still occur again, also without warning.
3- fight with it, and reset the page breaks--- fails on every level
imaginable (no solution).
4- blow up computer--- definitely fails on every level imaginable, and
pisses off the mgmt, requiring them to spend unbudgeted moneys, as well as
garner a reprimand to record (no solution). Thankfully, I'm not that
dense....
5- follow instructions when error occurs, and attempting to correct
manually. The instructions state to go to page layout tab, turn off page
breaks, reset page breaks, etc.... Nothing changes-- no solution.
6- the repair recommended did not affect it (no solution).
7- neither did the other item mentioned (configuring the page layout-
margins, paper size, orientation, headers, footers, etc....), because all
that had been previously performed when establishing the templates from which
the individual worksheets were created-- some 4 years ago (not problem;
therefore- no solution).
Hence my reason for coming here.
So far, the only viable (workable) solution found is to close program, and
lose whatever work done leading up to the break down in page breaks,
following the previous save.
Other ideas, and viable repairs would definitely be appreciated.
Thank you.
TheresaG
there doesn't seem to be a solution here on the MS site. Could it be a virus?
Thanks,
Gord Dibben
What does your AV application turn up when you scan your system?
Gord Dibben MS Excel MVP