Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pagination in Excel (2002)

    One of my users is trying to paginate a series of spreadsheets but doesnt want continuous pagination. She wants to include in the footer the page number but miss out occasional pages. Upto now she has managed this by using &[Page]+x where x is a number continued. Now when she does this, unless she puts a bracket or quote around the whole formula, she gets the page number followed by the second number and not added to the original e.g. If she wants page 8, she had been putting &[Page]+7 but now that gives 17 and not 8, unless in parentheses. Oddly, on some of the earlier numbers it works fine.

    Any ideas?

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

    Re: Pagination in Excel (2002)

    Can she duplicate this new problem on a split new Workbook - so we can tell whether it is specific to her report or to her entire Excel installation?
    Gre

  3. #3
    New Lounger
    Join Date
    Mar 2004
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pagination in Excel (2002)

    yes, I can try this but it goes awry even in the same excel document so I am not sure this will prove anything.

    Rob

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

    Re: Pagination in Excel (2002)

    I was just trying to rule out the possibility of the Workbook having started to become corrupted.
    Gre

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pagination in Excel (2002)

    It seems that putting any text after the "formula" forces it to calculate, so for example putting a space after &[Page]+7 should do the trick.

  6. #6
    New Lounger
    Join Date
    Mar 2004
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pagination in Excel (2002)

    Thanks Hans

Posting Permissions

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