Excel 2007 zoom problem - Page break to normal view

Posted on 2011-04-20
Last Modified: 2012-05-11
Hi Experts

We recently updated from Office 2003 to Office 2007.
Unfortunatly some issues have arrisen since the update.
This one I cant seem to solve by myself.  I hope you guys can help me out.

OS: Windows 7 Ultimate
Office: Office 2007 with all latest updates installed.


1. A user opens a fairly large spreadsheet and changes the zoom size to get a better overview
2. He switches to page break view to check the page breaks
3. He switches back to the normal view and suddenly his zoom size is back to 100%

Does anyone know how you can make sure that the zoom size for the normal view remains unchanged after you checked the page-breaks view?  Changing his default Excel template is not an option as his zoom size is not the same for all spreadsheets.

Thx in advance!

Question by:Insr33
    LVL 30

    Expert Comment

    AFAIK that is the default behavior. :(


    Author Comment

    Hi Sid

    Thx for the reply.  I'm also afraid that there is not a solution for this.
    Hopefully someone knows a solution.  Perhaps a macro?
    LVL 30

    Expert Comment

    There is no built-in real-time monitoring of the state of 'View' either by VBA or Non VBA. At least I am not aware of it.


    Author Comment

    No Solution for this?
    Upgrade to Office 2010 is not an option unfortunately :/
    I found another thread dealing this issue but also no solution..

    Accepted Solution

    I've found a workaround for this problem.

    Apparantly if you switch from the "Normal view" to the "page Layout view" before you switch to the "page break" view, It does not change your original zoom size if you switch back.  Its not the best solution but I can live with it.  If anyone should have a better solution, do tell :)

    Author Closing Comment

    Found a solution myself.  Not perfect but it works

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    734 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

    22 Experts available now in Live!

    Get 1:1 Help Now