Excel Page Break Issue.

Posted on 2006-05-07
Last Modified: 2006-11-18
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.
Question by:Afterlife
    LVL 80

    Expert Comment

    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:
    Another popular free site is AngelFire
    Google is also trying to encourage people to post files with them.

    If you don't want to sign up for one of the above services, then provides a free service at

    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,


    Author Comment

    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?
    LVL 80

    Expert Comment

    LVL 80

    Accepted Solution

    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.

    Author Comment

    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.
    LVL 80

    Expert Comment

    Thanks for the grade!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
    Outlook Free & Paid Tools
    This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now