Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Click here to return to the 'Set Excel 2008 default zoom level via AppleScript' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Set Excel 2008 default zoom level via AppleScript
Authored by: noahjz on Dec 02, '10 07:21:17AM
ede's comment above does work to set a default zoom level for new windows, but there was an extra step for me to get it to work. The part about making absolutely sure the suffix is not part of the file name was trickier than it seems. To get it work I had to:

1. Change the finder prefs (not system preferences) then select "show all filename extensions." I am not positive but I think this defaults to off, which makes the finder automatically hide extensions, so you think you've saved your excel template "workbook" without an extension but really it is just hidden.

2. Manually remove the .xltx from the file name in the finder.

3. Quit and re-launch excel.

As pointed out by the original hinter, this won't fix the zoom problem for old saved files, but it will make new windows zoomed, which is good enough for me.

I am pretty annoyed at how difficult Microsoft makes this basic preference configuration, and a little surprised that nobody is bashing Microsoft about it. I searched Excel Help within the program and searched the MS website and found nothing from Microsoft on how to fix this (although there were several windows-specific solutions which did not apply to OS X). It is sort of insane that to fix a user-interface design flaw which has existed in this software for as many versions as I can remember using, it was easier for someone to write a script than to find out the "right" way, i.e. adding a workbook.xlxt to startup folder (although obviously this is less functional than the script, in that the script will auto-zoom old excel files). I don't mean anything negative against the scripter, and kudos to him or her, it is just a reflection on how horrible Microsoft's support is.

[ Reply to This | # ]