CompuServe Messages

Hi Bob, Yes…I had the same problems. It isn't too surprising since fedtax.wks was written for 1-2-3 version 2 and Analyze only imports 1-2-3 version 1.4 or before. The way I solved the problem was to do essentially what you discovered…ie: once I got it read in I quickly saved it in .sht format. Then I started Analyze again with the original 1-2-3 version and ANOTHER analyze with the analyze version of the sheet. Then I found that I could use the formula export feature to export a formula out of the .wks and import it into the .sht. That took care of most of the "garbage" that appeared in the .sht version. The .wks version made fairly heavy use of lotus's new string functions, which we don't have in Analyze, so I called the Author to get help on that since the formulas didn't even show up in Analyze. I didn't feel too bad about all this…Lotus 1-2-3 version 1.4 won't even ATTEMPT to read a .wk1 file…even if you change the extension. So, the amazing thing is that Analyze was able to import the sheet at all! Rick Schaeffer