Lotus 123 - Saving to an earlier release.

I currently have several Lotus 1-2-3 documents which have been saved as release 9. I'm working with another user who has an earlier version of Lotus 1-2-3 (Release 5). I have saved the files as .WK4 so they can be opened using the earlier release, though when he attempts to open the documents he gets 'UNABLE TO OPEN FILE'. Notes suggests that the file doesn't exist or the disk is corrupted although it can be opened on the later version. It's not the PC as I've tried this on several others. It's not the diskette. I think it's the way I'm saving the file. Can anyone help?
jxsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ab9758Commented:
jxs
Play first.
You may need to start playing with backward versions.  I use 123 Mil 9.5 but keep an old 123R5 for Win3.1 for some work.  How big are the spreadsheets you're saving.  *.wk4 versions easily double the size of their matching *.123 copy.
Have you tried saving in 123 as following to see what happens when he opens them.
*.123 97 workbook, then
*.wk4, then even
*.wk3  (*.wk3 and I think wk1 both require (create?) *.fmt files to show formating.
You've tried reopening your converted files by Open As *wk4 to see if you can replicate the problem?
Still playing, but have you sneaked any scripts or macros into the files? Are you using any exotic *.12m smartmaster templates?
There is a workaround for damaged *.wk4 files on the Lotus Support site, but this is only really relevant if you are working and saving in *.wk4.  
Another thought.  Is his Release 5 the 16bit version?  Unsure if it has any impact, but make sure you save with 8.3 filename, not long filename.
And of course, files can corrupt.  I had a whole batch blip on me with no explanation on 123 and get the same error message.
Try a single sheet file with minimal info in it to pin down if size is an issue.
0
P_S_PriceCommented:
You could always try to save them in a non-Lotus Format common to both and then Import into the lower version
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jxsAuthor Commented:
P_S_Price gave me several options to choose from. Saving the file as*.123 then to *.WK3 worked. Thanks.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

ab9758Commented:
Can I have a minor tantrum?!!!
Could jxs explain the difference between my comment posted six hours earlier and PS Price's as to which solved the problem?
0
jxsAuthor Commented:
You can if you want. I've never used this facility so I was'nt aware of any 'earlier comment'. where can I find this?
0
ab9758Commented:
about half an inch above the previous comment!  Make sure whenever you come back to the site you click refresh (unless your browser does automatically - which isn't the default)
otherwise you may well be reloading a saved page from earlier in the day.
Now, can you hand on heart say that PS Price was your true salvation!!!
It's amazing what depths we go to for those points!!
0
ab9758Commented:
about half an inch above the previous comment!  Make sure whenever you come back to the site you click refresh (unless your browser does automatically - which isn't the default)
otherwise you may well be reloading a saved page from earlier in the day.
Now, can you hand on heart say that PS Price was your true salvation!!!
It's amazing what depths we go to for those points!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Hardware

From novice to tech pro — start learning today.