Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Archive: Business Applications Archive: Business Applications
Search Search
Search for:
Tech Support Guy > > > >

Solved: Opening Lotus 123 files in Excel


(!)

MzLizz's Avatar
MzLizz MzLizz is offline
Member with 158 posts.
THREAD STARTER
 
Join Date: Aug 2003
Location: New Hampshire
Experience: Intermediate
04-Nov-2003, 01:20 PM #1
Question Solved: Opening Lotus 123 files in Excel
Hello again all.

I'm trying to open a Lotus 123 file in Excel to convert it to Excel. It's been working fine. But this one particular file gives me the error message: "Cannot Open Lotus 123 file"

It is saved in the current version of Lotus just like the rest.

Any ideas?

Thanks again!
~Mz
XL Guru's Avatar
Senior Member with 2,702 posts.
 
Join Date: Aug 2003
Location: nr. Cambridge, England.
Experience: there's no substitute for it, apparently
04-Nov-2003, 01:55 PM #2
>> It is saved in the current version of Lotus just like the rest

(I'm guessing since I've never done owt with 123) suggests the file itself is corrupt. Or (totally guessing) has incompatible features that the others don't.

Can you try another machine? If it's OK to mail I'd be glad to have a go.

Rgds,
Andy
MzLizz's Avatar
MzLizz MzLizz is offline
Member with 158 posts.
THREAD STARTER
 
Join Date: Aug 2003
Location: New Hampshire
Experience: Intermediate
05-Nov-2003, 10:25 AM #3
Good Morning XL! Thanks for your answer!

I'm going to email you the file. I thought the problem could have been that it was a .123 file instead of a .WK4 file. But, I've saved it as a .WK4 file so that shouldn't be it.

The file is 5 worksheets. If I try to save it as an .XLS file in Lotus it gives me an error saying "This workbook contains multiple sheets. To avoid losing information, save it to a file type that allows multiple sheets.

And... I tried copy/paste from Lotus to Excel, but it loses its formulas.

Eek!

Any help you could offer would be appreciated!
~Mz
roseventura's Avatar
roseventura roseventura is offline
Computer Specs
Junior Member with 2 posts.
 
Join Date: Aug 2008
Experience: Advanced
13-Aug-2008, 10:16 AM #4
I am having the same problem with 1 of 2 files I was sent. I work in IT Support and someone sent me 2 *.wk4 files to convert to XLS. I was able to convert on, but I am receiving the "cannot open Lotus 123 file" on the second. I have tried several different approaches, but nothing is working. I tried renaming the file and saving it first to desktop. No go.
jimr381's Avatar
Computer Specs
Member with 4,175 posts.
 
Join Date: Jul 2007
Location: Vienna, VA
Experience: Computer Illiterate
13-Aug-2008, 01:46 PM #5
I wonder if the file is macro enabled. Ask them how the two files differ so we can try to figure out what they have done differently. Maybe they have a list established? Also please make sure you are running the most recent compatibility pack. What version of Excel are you using?
roseventura's Avatar
roseventura roseventura is offline
Computer Specs
Junior Member with 2 posts.
 
Join Date: Aug 2008
Experience: Advanced
13-Aug-2008, 03:16 PM #6
Cannot open Lotus 123 file
Unfortunately the end user does not know if the Lotus file has a macro in it.

To answer your other questions, I am using Excel 2003.

Not much help I know...

Thanks,

Rose
jimr381's Avatar
Computer Specs
Member with 4,175 posts.
 
Join Date: Jul 2007
Location: Vienna, VA
Experience: Computer Illiterate
13-Aug-2008, 04:01 PM #7
Quote:
Originally Posted by MzLizz View Post
Good Morning XL! Thanks for your answer!

I'm going to email you the file. I thought the problem could have been that it was a .123 file instead of a .WK4 file. But, I've saved it as a .WK4 file so that shouldn't be it.

The file is 5 worksheets. If I try to save it as an .XLS file in Lotus it gives me an error saying "This workbook contains multiple sheets. To avoid losing information, save it to a file type that allows multiple sheets.

And... I tried copy/paste from Lotus to Excel, but it loses its formulas.

Eek!

Any help you could offer would be appreciated!
~Mz

What about saving it as an Excel file directly from Lotus 123?
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑