[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • Last Modified:

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?
0
jxs
Asked:
jxs
  • 4
  • 2
1 Solution
 
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
 
jxsAuthor Commented:
P_S_Price gave me several options to choose from. Saving the file as*.123 then to *.WK3 worked. Thanks.
0
Evaluating UTMs? Here's what you need to know!

Evaluating a UTM appliance and vendor can prove to be an overwhelming exercise.  How can you make sure that you're getting the security that your organization needs without breaking the bank? Check out our UTM Buyer's Guide for more information on what you should be looking for!

 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now