Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert XL Objects into 2nd XL file (XL 97, SR-2)

    Situation:
    - Excel worksheet with 5 rows at the top - formatted like page titles
    - data is entered in rows

    Problem:
    - first 5 rows (headings) have different column widths than the data rows

    Workarounds Tried:
    - created separate workbook with one sheet - just containing the headings.
    - attempting to insert the headings into original file as an "Object" - but object is truncating headings on the right
    - attempt to insert two smaller objects side-by-side... 2nd object moves after the file is saved (result: space between the two objects)

    Any ideas? Headings need to be editable. (not possible to convert to Word & use tables)

    Clare

  2. #2
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Insert XL Objects into 2nd XL file (XL 97, SR-2)

    Clare,

    Sounds like you need to "Auto-Fit" the columns.
    Select the columns in question then (on the Menu bar) go to: Format | Column | AutoFit Selection.

    Jim Cone
    San Jose, CA

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert XL Objects into 2nd XL file (XL 97, SR-2)

    Clare attach a shot of your spreadsheet. I can't picture a 5 row heading being part of a desireable table design. (must be less than 100kb)

    -Lenny

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

    Re: Insert XL Objects into 2nd XL file (XL 97, SR-2)

    You might try this:

    - insert a second sheet
    - copy the headings to there and format the way you like them
    - Select the heading on the second sheet
    - Hold the shift key and choose Edit, copy picture
    - go to the other sheet, selec twhere the pic has to go and press paste
    - Now select the picture
    - click once in the formula bar
    - type the equal sign and navigate to the heading on the second sheet
    - select the entire heading and press Enter.

    Now you can edit and format the header on sheet 2 and adjust its width on sheet1.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    New Lounger
    Join Date
    Aug 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert XL Objects into 2nd XL file (XL 97, SR-2)

    Hi Jan,

    Thank you for the procedure - it may be able to work but... I got an error: "The picture is too large and will be truncated". I checked on MS TechNet and didn't find any articles that might explain this. Do you know of any limites to the size of pictures?

    The headings on the 2nd sheet are 5 rows deep and from column A - BA (all columns widths = 3).

    I have attached the file for your review...

    Clare
    Attached Files Attached Files

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

    Re: Insert XL Objects into 2nd XL file (XL 97, SR-2)

    If it says Too large, I guess there is nothing we can do about it.

    One workaround would be to have multiple smaller pictures next to each other, e.g. consisting of ranges of the size as the are shown on the printout. But I doubt this is going to be very "workable". I would suggest reconsidering this design.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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