Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    View PageBreaks (Excel2000)

    Problem: Tools/Options/View and marking Page Breaks only works per sheet (not even worksheet) per session. Other options in this tab, and even that section "stick".
    I have tried this on three separate computers (two networked, one standalone) and all demonstrated the same symptom.
    Has anyone come across this problem? Found a way to fix it? (or should I put this down to a quirk of the Hebrew-enabled Office?)
    Thank you for your help.

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: View PageBreaks (Excel2000)

    Actually, not just a quirk of Hebrew office. Behaves the same way here in Canada too!
    I gather you want your pages breaks displaying at all times everywhere?

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View PageBreaks (Excel2000)

    I am actually glad to see it's a worldwide problem, because this increases the chances that someone will find a solution. It seems elementary to wish to see page breaks as a default view; and I guess Microsoft thought so as well, otherwise they would not have offered the option.

    Thank you for letting me know it's not something I am doing wrong.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View PageBreaks (Excel2000)

    You should know, that what you set under Tools, Options is sometimes an application level, sometimes a workbook-level and sometimes a sheet level setting. Which type a setting is, is not always obvious.

    Setting page break view can dramatically slow down the performance of XL, since at every move, XL consults the printerdriver extensively before doing anything.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: View PageBreaks (Excel2000)

    If you don't have a book.xlt file in your XLStart directory - you'll have to make one (this becomes the default template for all new blank files). Then place this piece of code in the book.xlt file:
    <pre>Sub ShowAllPageBreaks()
    Dim Sh As Worksheet
    For Each Sh In Worksheets
    Sh.DisplayPageBreaks = True
    Next
    End Sub
    </pre>

    I'd attach it to a button so I can run it whenever I like.
    One of the other Excel VBA gurus can tell you if it should go in the Workbook or a module (and perhaps they'll explain the difference to me along the way <img src=/S/grin.gif border=0 alt=grin width=15 height=15>).

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  6. #6
    Star Lounger
    Join Date
    Jan 2001
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View PageBreaks (Excel2000)

    Whatever level it is, I would expect it to "stick" so once I define it (even per sheet) that the next time I open the document the setting will be there, and it is not.

    However, since I can't have what I want I will take comfort in the fact that at least my XL is faster than it would have been. Thanks for pointing this out.

  7. #7
    Star Lounger
    Join Date
    Jan 2001
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View PageBreaks (Excel2000)

    Thanks. I'll try this out. I had hoped for a solution that did not require VBA, as I support over 300 stations, most not even knowing what a macro is. But at least your solution can make my own work easier, and for that I am grateful to you.

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View PageBreaks (Excel2000)

    It should "stick", but of course the workbook would have to be saved...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View PageBreaks (Excel2000)

    If you format a sheet the way you want and save it as "Sheet.xlt" in the same directory as Book.xlt, all should be well and no VBA needed.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  10. #10
    Star Lounger
    Join Date
    Jan 2001
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View PageBreaks (Excel2000)

    It is being saved, naturally. But the view/pagebreaks setting does not get saved with it - and it's more than one workbook. By the time I approached the Lounge I have tried it on a number of computers over a period of time.

    I wish the solution could have been this easy.

  11. #11
    Star Lounger
    Join Date
    Jan 2001
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View PageBreaks (Excel2000)

    The problem is that I cannot format a sheet the way I want, because this setting is dis-selected sometime between closing the workbook and reopening it.

    This is really wierd. Can you get this setting to stick on your computer (with Excel2000)?

  12. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View PageBreaks (Excel2000)

    I tried this (xl2K):

    - Open single-sheet workbook;
    - set pagebreak view to on
    - save file as sheet.xlt in the XLStart directory
    - save file as book.xlt in the XLStart directory

    Now once you create a new workbook or add a sheet, pagebreak view is on by default.

    Also, when I open an existing file and set page break view , save and reopen, the view sticks (and only to the sheet I changed it to).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  13. #13
    Star Lounger
    Join Date
    Jan 2001
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View PageBreaks (Excel2000)

    Thank you for your detailed instructions. Regretfully, it doesn't work. Excel refuses to save this setting (I have changed other settings, such as a default footer - which did show up, so I know what I did was right).
    I will try it at home, to make sure it's not a specific problem with my computer, but I doubt it.
    Very depressing as the fact that it works on your computer shows there must be something I can do. Could it have anything to do with Windows version? I have this problem on Win95 and Win98.
    Thanks again for taking the time to help.

  14. #14
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View PageBreaks (Excel2000)

    Are you sure you put the xlt files in the xlstart directory?

    Also, make sure you have the correct one... check if there are multiple xlstart dir's on your system.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  15. #15
    Star Lounger
    Join Date
    Jan 2001
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View PageBreaks (Excel2000)

    Regretfully, I am sure it is in the right xlstart directory.
    I made double-sure by correcting a few other settings, and those settings are coming up in new workbooks. Only the page break isn't - and when I go to the *.xlt the option is not selected, even though I double checked after saving and before closing that it was selected.
    I tried selecting and saving three times, being the optimist that I am, but no luck.
    Thank you for trying. I'd love to try any other ideas that you or others on the Lounge may have (and am still to try the VBA, but as I said - this is a compromise for me as I want to offer this option organization-wide).

Page 1 of 2 12 LastLast

Posting Permissions

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