Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    May 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing Excel spreadsheets (2000)

    Having set up an A3 sheet in Word (landscape) and importing an Excel spreadsheet, I find that there is no way of showing all of the columns in the spreadsheet - it misses the last 10 columns. Is there a maximum width of an imported sheet that anyone knows of?

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

    Re: Importing Excel spreadsheets (2000)

    An Excel worksheet has 256 columns. A table in Word has a maximum of 63 columns.

    If you really need more than 63 columns, consider importing the worksheet as an Excel object.

  3. #3
    New Lounger
    Join Date
    May 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing Excel spreadsheets (2000)

    Thanks - but it is imported as an Excel object already. There are only 29 columns - which is why this is a little confusing. Could it have anything to do with an object size limit as the page is A3 not A4? <img src=/S/help.gif border=0 alt=help width=23 height=15>

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

    Re: Importing Excel spreadsheets (2000)

    I just did some experimenting with a 200 column table in Excel. The number of columns displayed in Word seems to be the max that fit inside the document window. This is influenced by the column width in Excel.
    When I make the columns wide (in Excel), only 19 columns are visible in Word (Landscape A4). When I make the columns narrow, 89 columns are visible in Word. In both cases, the "missing" columns are visible if I double click the object, and disappear again when I click outside the object.

  5. #5
    New Lounger
    Join Date
    May 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing Excel spreadsheets (2000)

    Same problem I am having - it seems that any imported object can only be of a certain width. Found another solution though - will just scale an A4 page to A3 instead and make the font very small in the Excel spreadsheet. Thanks for your attempts!! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

Posting Permissions

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