Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1


    Member Since
    Sep 22, 2007
    Posts
    2
    Excel page setup problem
    Using Office for Mac - Excel

    I created at worksheet and setup the sheet as legal size - 8.5x14 in landscape layout. Then save it that way.

    However, when I re-open the file, it opens as letter size - 8.5x11.

    Any ideas as to what I'm doing wrong?

    Thanks

  2. #2

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,187
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    File > Page Setup > Page > Options... > Paper Size
    Select US Legal, and the "sideways" icon for landscape.

    If that's the way you did it, you did nothing wrong. Those settings should be saved with the file.

  3. #3


    Member Since
    Sep 22, 2007
    Posts
    2
    That's what I thought, still... it is not working

  4. #4

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,187
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    You could try isolating the plist file and generating a new one to see if that would fix things. Or, try Escel from a different user account and see if it behaves.

  5. #5


    Member Since
    Jan 05, 2012
    Posts
    23
    Excel 2008 for Mac Page Setup
    I have been sweating over the same problem all afternoon. I cannot get my spreadsheet to save a Legal page size in the Page Setup Dialog. When I quit Excel and save it, the next time I open the spreadsheet it has reverted to US Letter Borderless for some strange reason. I even clicked Save as Default in the dialog drop down and it doesn't help.
    I'm very frustrated with this problem and would welcome suggestions. I have just upgraded to Lion so that may have something to do with it.

  6. #6


    Member Since
    Jan 05, 2012
    Posts
    23
    Excel Page Setup
    I took the advice of toMACsh and logged in as another user. Excel worked fine. So trashing the pref file should fix it.

  7. #7

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,187
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    Quote Originally Posted by Dave Wightman View Post
    I took the advice of toMACsh and logged in as another user. Excel worked fine. So trashing the pref file should fix it.
    Not necessarily, but perhaps.

  8. #8


    Member Since
    Jan 05, 2012
    Posts
    23
    Excel Page Setup
    You're right. It doesn't necessarily fix it because the original problem file still doesn't work. I was able to bring the file that worked in the other user into my user via the Shared user folder and it works OK. It's only full page charts that gave me the problem but the page size kept reverting back to Letter from Legal. Maybe the file itself was corrupted somehow.

  9. #9


    Member Since
    Jan 05, 2012
    Posts
    23
    Excel Page Setup
    Now even the file I brought over from a different user on my mac is reverting to Letter. Excel 2008 under Lion simply won't remember its page setting. Don't know whether it's an Excel problem or a Lion problem. I do know that the Page Setup reverts to whatever you've set as default in the Print and Scan System Preferences pane. That's the only way I could get it to retain a Legal paper size setting. By the way I did a complete uninstall of Excel including all pref files and then reinstalled it. No change.

  10. #10

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,187
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    Dave, the problem is somewhere in your User Account. It didn't fail under a new account. You tried the plist file, and that didn't help. You can pull your hair out trying to figure out what is corrupt. You will fail. Bite the bullet and move all your files to a new account. Once you get 'em all, trash the bad account.

  11. #11


    Member Since
    Jan 05, 2012
    Posts
    23
    OK - You're right. I'm in the process of transferring now and it's not as easy as it sounds. I have to avoid transferring the user library for fear it's the source of the corruption so I have to re-setup mail and everything!
    Thanks for your help though MAC.

  12. #12

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,187
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    You're welcome.

    That's Macintosh, or rather MAC in tosh... toMACsh

  13. #13


    Member Since
    Jan 05, 2012
    Posts
    23
    Back Again
    After going to the considerable trouble of creating a new user and transferring all my files I thought I had the problem solved. It worked fine from 11 January until today 18 January and I opened the file every day. Now today it's back to its old behaviour of reverting Page Setup to US Letter. It won't remember the page setup at all. When it's working it's saving the page setup for each worksheet in a file so it can't really be the Pref file, it's got to be saved with the document file itself. When it's not working it reverts to whatever page size is set as default in the Print and Scan system preferences for the printer.
    Wonder if Capt Steve ever solved it or if toMACsh has any more ideas?
    Dave

  14. #14

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,187
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    Quote Originally Posted by Dave Wightman View Post
    Maybe the file itself was corrupted somehow.
    Quote Originally Posted by Dave Wightman View Post
    Wonder if Capt Steve ever solved it or if toMACsh has any more ideas?
    Only one: Open a blank file and copy and paste everything from the problem file.

    If more than one file is a problem, that won't help, of course

  15. #15


    Member Since
    Jan 05, 2012
    Posts
    23
    Still working on this but failed again. Used a new User again and started from scratch. Worked OK for a few days then Excel refused to save the page setup and always reverts to US Letter. It's a mystery!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Page numbers in Excel for Mac
    By khowell in forum OS X - Apps and Games
    Replies: 2
    Last Post: 03-01-2013, 01:26 PM
  2. Print page setup?
    By Phacade in forum Switcher Hangout
    Replies: 9
    Last Post: 05-31-2011, 07:41 PM
  3. Managing Office Page setup
    By StephenTimms in forum OS X - Operating System
    Replies: 1
    Last Post: 05-27-2010, 01:35 PM
  4. Printing no page setup options
    By livefortoday649 in forum Other Hardware and Peripherals
    Replies: 0
    Last Post: 01-11-2010, 12:51 PM
  5. Best setup for gaming & advanced excel
    By chssvl in forum Running Windows (or anything else) on your Mac
    Replies: 4
    Last Post: 04-14-2009, 03:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •