Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2005
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel converted from Lotus issues (Excel 2002 SP3)

    We have some users that have Excel files that were long ago converted from Lotus (sorry, that's all the detail I know). These files have issues, such as formatting issues and not promting for read-only when another user has the file open. I think they got slightly corrupted, weren't entirely compatible for converting, or they didn't do it right. Does anyone know of any tools that might be used specifically for this issue, or any online knowlege resources that might be able to help? Has anyone had any experience with this?

    Thanks in advance for your help.

  2. #2
    3 Star Lounger
    Join Date
    Nov 2004
    Location
    Nottingham, Nottinghamshire, United Kingdom
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel converted from Lotus issues (Excel 2002 SP3)

    Hi, and welcome to the Lounge!

    Do you happen to know which version of 1-2-3 these files were created in? What sort of formatting is contained in these files? I used to use 1-2-3 but haven't done any conversions for a long time. Have you tried the Lotus website?

    Failing that, you may have better luck posting this (or an Admin may move it) to the Software board.
    <font color=448800><font face="Comic Sans MS"><big>Lyra J </font color=448800></font face=comic></big>
    <img src=/S/flags/UK.gif border=0 alt=UK width=30 height=18> Ducking the arrows in Robin Hood country <IMG SRC=http://www.wopr.com/w3tuserpics/Lyra_J_sig.gif ALT="No, Admins, no! I'm sorry, okay!" title="No, Admins, no! I'm sorry, okay!">

  3. #3
    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 converted from Lotus issues (Excel 2002 SP3)

    One trick that may overcome some of the corruption (but not the fomatting problems), is to save them as HTML and then open them from HTML and re-save as XLS.
    -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
  •