Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    page of pages problem (Excel 2000)

    I recall their was a problem in Excel 5 with multiple paged spreadsheets where it used to number wrongly. I seem to have a similar problem with an Excel 2000 spreadsheet. I have selected all sheets, File Page Setup, put in a custom footer saying Page &[Page] of &[Pages] but when I print preview I get 10 pages saying Page 1 of 12 and a couple saying 2 of 12. Any ideas?
    Neil Eustice
    Woody Worshipper

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: page of pages problem (Excel 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Neil

    OK when you say <<< <font color=red> I have selected all sheets </font color=red> >>> do you mean you selected the first worksheet by selecting its tab and then pressed the Shift key and selected all the other worksheets by pressing on their tabs?

    if that is the case, all the pages will be the total of all the worksheet pages, so you will get this numbering discrepacies.

    You should select each worksheet by itself and print Entire workbook from the print dialog.

    Ask Bob Umlas for any help, I think he is in building 2.

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: page of pages problem (Excel 2000)

    Although I tested with a workbook with far less data, I could not reproduce your problem. There aren't any hidden sheets in the workbook are there? Also JIC, was the file created in Excel 2000? HTH
    Gre

  4. #4
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: page of pages problem (Excel 2000)

    I actually right clicked on a sheet and said select all sheets. Then I set the page up with the footer, which applied to all the pages. Surely you are not saying I should set the footer up individually on each page?
    Neil Eustice
    Woody Worshipper

  5. #5
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: page of pages problem (Excel 2000)

    I have attached the workbook (with data deleted). See what you think. It is definitely 2000.
    Attached Files Attached Files
    Neil Eustice
    Woody Worshipper

  6. #6
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: page of pages problem (Excel 2000)

    Try looking at it in Page Break Preview. You'll find that the last page (in the version you sent me) actually splits out into two pages. I think you must have wanted the Fit to 1 x 1 page option. For some reason you have at Fit to 1 x 2.
    Gre

  7. #7
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: page of pages problem (Excel 2000)

    I have found the problem of Neil

    Neil, inside de "Setup page " write in " first number of page" => "automatic ". You had put the 1 and was forced to always initiate with that number.

    (see the attachment file)

    I hope you understand my bad English
    Attached Images Attached Images

  8. #8
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: page of pages problem (Excel 2000)

    Sir, you have hit the nail on the head. Thank you.
    Neil Eustice
    Woody Worshipper

  9. #9
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: page of pages problem (Excel 2000)

    Thanks, but look at the answer from Servando, he found it.
    Neil Eustice
    Woody Worshipper

Posting Permissions

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