• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 485
  • Last Modified:

Excel Page Break Issue.

I dont know when or how this started, but I opened up Excel 2003 and made a simple spreadsheet. 5 columns, 8 rows, font 12, all columns were empty as it was to be printed out. I styled it and clicked print preview to find none of my work on the PP screen. In fact there was now 10 pages of nothing, some had my formatting...

upon further investigation if i switch my view to page layout, i see dozens and doezens of pages with only 1 row, switching to page break preview shows all my information over about 20 page breaks. I cant even delete them as it tells me some bogus error about not being able to move page breaks due to it reducing the scale below 10%.

I even uninstalled office, reinstalled, uninstalled and installed office beta 2007, and still all the same error.

Ive tried searching for a way to reset all settings to default and cant find anything.

Ive checked to see if its opening a default .xlt and its not.

So if anyone has any idea how I can fix my excel back to default id really appreciate it.
  • 4
  • 2
1 Solution
Hi Afterlife,
1) What paper size are you using? What margins? In correct settings here can make it impossible to put more than a handful of cells on a page.
2) Could you post a link to your workbook? Sometimes the problem becomes clear when you can see the actual document.
3) Have you tried resetting your *.xlb toolbar file to factory defaults? This does not occur when you uninstall/reinstall Excel.

Many ISP allow their customers to create a personal web page. If so, you can post your file there, and then put the link in a Comment. This is the approach that I take.

You can post your file for free at Geocities:  http://geocities.yahoo.com/ps/learn2/HowItWorks4_Free.html
Another popular free site is AngelFire http://www.angelfire.lycos.com/doc/subscriptions/index.html
Google is also trying to encourage people to post files with them. http://base.google.com/base/default 

If you don't want to sign up for one of the above services, then RapidUpload.com provides a free service at http://www.rapidupload.com/

If none of the above work out for you, I would be willing to post a link to your file if you e-mail it to me. My address at the bottom of my Experts-Exchange profile--just double-click my screen name at the top of this comment.

Try resetting your *.xlb toolbar file to factory specifications. You do this while Excel is not running by renaming your *.xlb toolbar file to *.old. This file, which always exists but may be hidden, is frequently corrupted. After renaming, a new copy to factory specs will be created the next time Excel launches. Mine (for Excel 2003) is called Excel11.xlb and is located in my C:\Documents and Settings\my Windows log-on name\Application data\Microsoft\Excel folder. Another hiding place is C:\Program Files\Microsoft Office\OFFICE11\XLSTART. Your name and location may be different, so please search for it (and there may even be more than one on the computer).

If the preceding doesn't help, you may also want to  launch Excel with the RegServer option to reset the registry settings to factory specs. You do this from the Start....Run command line. On my computer, the command looks like "C:\Program files\Microsoft Office\Office11\EXCEL.EXE" /RegServer

Finally, consider removing any files you find in your XLSTART folder. These may contain macros that are causing the problems.

Adobe Acrobat and Norton Anti-Virus are known to have conflicts with Excel. Usually, upgrading to the latest version of these programs will solve the problem, but please post a comment if your computer has (or had) them installed.

Hoping to be helpful,

AfterlifeAuthor Commented:
Its not just excel anymore, word, everything is screwing up.

There is nothing in the XLStart folders, I cant determine why when I print the pages are all screwed.

Ill send the word and excel file, tho something tells me its not the files but my machine, i cant do anymore than uninstall the app, so office is just fudged for me.

I put the files on a different machine, and they dont act like they do on mine. Is there anyway of doing a complete uninstall, like ALL traces of any office file gone?
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

The Excel file opened fine in Excel 2003, and will print out on three pages using my default printer.
The other file would not open under Word 2003.

Since Word and Excel try to be WYSIWYG programs, they are both sensitive to corruption in printer and video drivers--Word especially so. Update both printer and video drivers by downloading the latest version from the manufacturer's web site, then reboot your computer.

Another way of testing whether your documents or Office/Windows installation is at fault is to boot your computer in Safe mode. If your Word and Excel files now behave properly, then your documents are not corrupted.
AfterlifeAuthor Commented:
Thanks Brad it was the printer drivers I had just installed a few weeks ago. I removed them and everything is back to normal now.

really appreciate it.
Thanks for the grade!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now