Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan - U.S.A.
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel (with Lotus ancestors)

    I have two Excel spreadsheets that I need to combine (as separate worksheets in the the same workbook). I thought it was a simple 'move or copy worksheet' deal - until I tried it. The formatting went goofy and even the row and column headers look strange. I suspected corruption, but I finally remembered that one of the files started life - way back- as a Lotus spreadsheet and has migrated through Office 95, 97, and finally, 2000. The other was created in Excel 2000.
    I really need good formatting - it's a catalog. And I'm not crazy enough to re-enter all this data.
    Anyone? Bueller? Anyone?

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excel (with Lotus ancestors)

    Hi,
    Have you tried inserting a new blank worksheet into the workbook originally created in Excel2000 and then copy and pasting all the data from the other worbook onto the new blank sheet?
    Just a thought.
    Regards,
    Rory

    Microsoft MVP - Excel

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

    Re: Excel (with Lotus ancestors)

    I don't know if turning on the Lotus transition would help. This is under Tools/Options/Transition. Good luck. I remember when we (at work) upgraded to Excel from Lotus and what happened to our spreadsheets. It was a mess.

  4. #4
    tfspry
    Guest

    Re: Excel (with Lotus ancestors)

    You might want to try a "paste special".
    Go to the sheet you want to COPY FROM. Click on the small square in the upper left (at the intersection to the left of Column A and above Row 1). Your whole sheet should then be highlighted. Choose Edit Copy or right click and choose Copy. Go to the workbook you want to Paste TO. Pick a blank worksheet go to that same small square in the upper left corner(see above) and choose Edit Paste Special click All and then click OK.

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan - U.S.A.
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel (with Lotus ancestors)

    I have tried pasting to a new worksheet. It still blows the column formatting (critical). In a wierd way, too. Columns 5 wide end up as 6.71 wide, etc. In fact I've tried every combination I can think of - moving #1 to #2, #2 to #1, #1 & #2 to a NEW workbook---you get the idea. I've also tried the paste-special. Same deal.
    The transition idea was interesting. I get the idea that it just sets a default format for saving, though. I couldn't figure out a good way to use it.
    Thanks for all the good ideas, though.

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

    Re: Excel (with Lotus ancestors)

    The transition purpose is to allow you to use the same keystrokes that you would have used in Lotus and have Excel recognize them. I still don't know if it will help though.

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel (with Lotus ancestors)

    Excel imports Lotus DOS spreadsheets with weird style formatting. One thing I found when migrating (it's been a while) is to reset the Style for the entire imported spreadsheet to one of your desired Excel defaults. This won't help you with column widths and row heights, but those are easy to fix.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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