We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Excel 2007 zoom problem - Page break to normal view

Medium Priority
767 Views
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.


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

Problem:

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!

 
problem.jpg
Comment
Watch Question

AFAIK that is the default behavior. :(

Sid

Author

Commented:
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?
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.

Sid

Author

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

http://social.technet.microsoft.com/Forums/en-US/excel/thread/f989b080-2d65-4a79-9d19-b3eb1cf1dcc7/
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Found a solution myself.  Not perfect but it works
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.