+ Reply to Thread
Results 1 to 14 of 14

Single page excel grows into multiple pages when sharing with others

  1. #1
    Registered User
    Join Date
    06-02-2015
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011 Mac
    Posts
    6

    Exclamation Single page excel grows into multiple pages when sharing with others

    Hi, I am working on an urgent project of creating a form for a client. I use excel 2011 mac and my client uses 2008 mac.

    I delivered the work as a single page excel, but my client said the form expands to multiple pages on his screen. Please see attachments.

    I asked him to adjust the margins and that did not solve the issue.

    I noticed from his screenshot that all the column widths and row heights were enlarged for some reason. I asked him to send back the excel he opened, and the file opened issue-free on my screen.

    I don't have access to excel 2008 and cannot duplicate the problem on my end. I tested the file on excel 2010 and it opened as single page. However I am not confident enough to suggest a version upgrade to my client. What if he spends the money and the issue remains?

    Is there a fix that I can do so the form stays single page in all versions, or at least on his version?

    I am supposed to offer a solution within 24 hours and am completely stressed out. Any help is appreciated!!!!! Thank you.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Single page excel grows into multiple pages when sharing with others

    Your client appear to be have his default Page Setup to Portrait instead of landscape view.
    This cuts the form off at Columns H-I.

    They could simply change the format back to Landscape in the Print settings.comicsans.jpg
    Last edited by daffodil11; 06-02-2015 at 06:57 PM.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    06-02-2015
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011 Mac
    Posts
    6

    Re: Single page excel grows into multiple pages when sharing with others

    Thanks so much for the fast response. I did not ask him to check page setup. From his screenshot his page width seems like 11 inch on the ruler, so I thought he already had it on landscape.

    Any other tip?

    Thanks again!

  4. #4
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Single page excel grows into multiple pages when sharing with others

    That's just the page size. Look at the bottom left of his screenshot: he's looking at the file in PageLayoutMode.

    Perhaps have them use Fit-on-One-Page print option.

  5. #5
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Single page excel grows into multiple pages when sharing with others

    I suppose it's possible regional settings could interfere with the measurements if the recipient is in another country.

    If so you could try adding the following code to the ThisWorkbook section of the VB Editor to dictate the sizes of the each column when the file is opened.

    Please Login or Register  to view this content.
    I've attached an example. Load this workbook but do not enable macros. Look at the columns. I've messed them up on purpose.

    Now load the workbook again, but this time Enable Macros. The columns adjust themselves to your original.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    06-02-2015
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011 Mac
    Posts
    6

    Re: Single page excel grows into multiple pages when sharing with others

    I just emailed him to check the page setup.

    However I am not completely clear about your suggestion. The page layout mode icon at the lower left corner always look like 2 pieces of portraits to me. The icon does not change to landscape even when I create a blank doc in landscape, or vice versa. What am I missing here?

  7. #7
    Registered User
    Join Date
    06-02-2015
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011 Mac
    Posts
    6

    Re: Single page excel grows into multiple pages when sharing with others

    My client is based in the US. but I will ask him about his regional setting. Where can he find this information?

    Again thanks so much!

  8. #8
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Single page excel grows into multiple pages when sharing with others

    Did you try the programming code that autocorrects itself?

  9. #9
    Registered User
    Join Date
    06-02-2015
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011 Mac
    Posts
    6

    Re: Single page excel grows into multiple pages when sharing with others

    I am not a excel power user and have never tried the programming tool. I will look into programming based on your instructions. Thanks.

  10. #10
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Single page excel grows into multiple pages when sharing with others

    To get there, enable the Developer Tab through Options->Customize Ribbon.

    Click VB Editor, and then double click on ThisWorkbook. Code there affects the whole workbook. The code I provided automatically runs when the workbook opens.

  11. #11
    Registered User
    Join Date
    06-02-2015
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011 Mac
    Posts
    6

    Re: Single page excel grows into multiple pages when sharing with others

    My client tested out the excel with the programming code you sent me. I asked him to open with both ways to enable and disable the macro. He tried both but the same issue still remains.

  12. #12
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Single page excel grows into multiple pages when sharing with others

    This may be caused by file formatting issues. Some data is lost in the compatibility process, though I've never witnessed something quite like this.

    Try saving you file as .xls (Excel 97 format) instead of .xlsx (2010 format).

  13. #13
    Registered User
    Join Date
    07-07-2015
    Location
    Memphis, TN
    MS-Off Ver
    2010
    Posts
    2

    Angry Re: Single page excel grows into multiple pages when sharing with others

    I am having the same problem. I have created a cell-protected form where the customer fills in only designated cells. I have revised this form previously several times. On my last revision, each page divided in half and went to a second page, doubling the number of pages. We have tried everything from margins, fonts, Protection of the document, orientation, scaling/unscaling, fit to one page/don't fit to one page, removed headers and footers, unmerge cells/merge again, reboot, etc. Nothing brings back the form to the right size. Seems like a bug in the programming that was triggered. I am in the USA using MS Excel 2010. Any ideas? Thank you.

  14. #14
    Registered User
    Join Date
    07-07-2015
    Location
    Memphis, TN
    MS-Off Ver
    2010
    Posts
    2

    Re: Single page excel grows into multiple pages when sharing with others

    A view of the first page as 2 pages is attached. Thank you for any feedback.
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Web Query - Import data from multiple pages into a single MS Excel worksheet.
    By vsssarma in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-01-2022, 12:11 PM
  2. Import data from multiple pages of a website into a single Excel workbook
    By kavin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-26-2015, 04:19 AM
  3. Replies: 0
    Last Post: 07-30-2014, 11:25 AM
  4. sum of multiple ranges sharing a single criteria
    By dr mint in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-21-2010, 12:22 AM
  5. Single worksheet, multiple pages?
    By Peter in forum Excel General
    Replies: 9
    Last Post: 01-23-2005, 06:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1