I want to open lotus 123 files in Excel 2007, later on I will want to be use Excel 2010, but for now Excel 2007.
I know that lotus 123 is NOT support in Excel 2007.
But I have hundreds of lotus 123 files going back some time.
I could run Office 2003, as it can import 123 files, but I don’t want to unless I have to.
I could run , lotus 123 and convert it into Excel docs, but I would prefer not to do so.
I could run Open office; but I don’t want to open that door full stop, minus 500 points to any one that suggests it :-).
I have seen “Information about certain file types that are blocked after you install Office 2003 Service Pack 3” (http://support.microsoft.com/kb/938810/
), and that dose talk about lotus files being blocked (.wk1, .wk4, .wj3, wk1 .wks, .wk3, wk3 .wj2, .wq1, .wj1 ) but I could not find a way of unblocking them. But this is talking about 2003 and not 2007.
I have worked out a data import workaround for a “.WKS” compatible spreadsheets. But it does not import the formulas into Excel 2007, only the data. To do this open a new or empty workbook open, then select the Data Ribon. Then from Other Sources select “From xml Data Import”, then browse & select the file and change Files types to "All files", then select and open. That gives you the data, formatting, and no formulas, just raw values where the formulas where.
But want I want is data and formula!
Are there any addins, any free or any paid for apps, or scrips or any way what so ever of reading .wk4 files in Excel 2007?