Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zoomed in files
Weird zoom/view issue.
We open any existing Excel file on one computer. Sheet1 is at 75% zoom/view. Sheet2 is at 100% zoom/view. Sheet3 is at 200% zoom/view. Open Excel and start a new one, and it is fine. Saves normally as well. Is there some setting that determines or sets the zoom/view like that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zoomed in files
The Zoom setting is retained by each worksheet in the workbook, so at some
point the zoom value was changed on the worksheets in question and saved with those settings. All new workbooks have the worksheet zoom setting at 100% -- Kevin Backmann "Mount_Dreamer" wrote: Weird zoom/view issue. We open any existing Excel file on one computer. Sheet1 is at 75% zoom/view. Sheet2 is at 100% zoom/view. Sheet3 is at 200% zoom/view. Open Excel and start a new one, and it is fine. Saves normally as well. Is there some setting that determines or sets the zoom/view like that? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zoomed in files
So, just to clarify, you are saying that someone went in, adjusted the zoom
on 50 excel files so that the Sheet1 is 75%, Sheet2 is 100%, and Sheet3 is 125%? Even though it is only affecting this one computer? "Kevin B" wrote: The Zoom setting is retained by each worksheet in the workbook, so at some point the zoom value was changed on the worksheets in question and saved with those settings. All new workbooks have the worksheet zoom setting at 100% -- Kevin Backmann "Mount_Dreamer" wrote: Weird zoom/view issue. We open any existing Excel file on one computer. Sheet1 is at 75% zoom/view. Sheet2 is at 100% zoom/view. Sheet3 is at 200% zoom/view. Open Excel and start a new one, and it is fine. Saves normally as well. Is there some setting that determines or sets the zoom/view like that? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zoomed in files
Is there a template in the XLStartup folder on that lone errant computer that
possibly has those zoom settings. That might be where the zoom assignments are being applied. -- Kevin Backmann "Mount_Dreamer" wrote: So, just to clarify, you are saying that someone went in, adjusted the zoom on 50 excel files so that the Sheet1 is 75%, Sheet2 is 100%, and Sheet3 is 125%? Even though it is only affecting this one computer? "Kevin B" wrote: The Zoom setting is retained by each worksheet in the workbook, so at some point the zoom value was changed on the worksheets in question and saved with those settings. All new workbooks have the worksheet zoom setting at 100% -- Kevin Backmann "Mount_Dreamer" wrote: Weird zoom/view issue. We open any existing Excel file on one computer. Sheet1 is at 75% zoom/view. Sheet2 is at 100% zoom/view. Sheet3 is at 200% zoom/view. Open Excel and start a new one, and it is fine. Saves normally as well. Is there some setting that determines or sets the zoom/view like that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I batch convert 97-2003 .xls files to 2007 .xlsx files | Excel Discussion (Misc queries) | |||
converter tool to convert XL 2007 files to XL 2003 files | Excel Discussion (Misc queries) | |||
Drive Erased, got Files back but only excel files scrambled, help. | Excel Discussion (Misc queries) | |||
How can I view files chronologically when opening multiple files | Excel Discussion (Misc queries) | |||
How do I format template zoomed? | Setting up and Configuration of Excel |