Problems When Using SQZ!, Lotus 1-2-3 Release 2.x,
And Norton Utilities' FileSave Or EraseProtect

If you get a "Not a valid worksheet" message when trying to retrieve a 
squeezed .WK! worksheet in Lotus 1-2-3 Release 2.x, check if you have the 
Norton Utilities' FileSave (Norton 5.0) or EraseProtect (Norton 6.0) in your 
AUTOEXEC.BAT file.  SQZ! has a compatibility problem with these two utilities.  
With Norton 5.0, the FileSave command will be listed in your AUTOEXEC.BAT as 
FILESAVE /ON or FS /ON;  in Norton 6.0, the EraseProtect command will be 
listed in your AUTOEXEC.BAT as EP /ON.

When you save a file with SQZ! enabled, SQZ! first creates two temporary files 
in which it does its work.  Second, SQZ! filters (what would be) your .WK1 
spreadsheet's data into these temporary files.  Third, SQZ! deposits the 
distilled data from the temporary files into the familiar .WK! file.  Last, 
SQZ! deletes the temporary files.  Unfortunately, the FileSave and 
EraseProtect utilities interfere with SQZ!'s processes, and the result is that 
the temporary files do not get deleted.  In some cases, the files left on the 
computer have eight character filenames composed of random numbers and 
letters.  In other cases, the files left behind are named ROWSINFO.xxx and 
FORMINFO.xxx.

The corruption of your worksheets and the subsequent error messages may not 
occur until you have up to twelve or thirteen copies of these temporary files.  
These temporary files can be safely deleted.  Damaged .WK! files can be 
recovered by using SQZ!'s SQZTOOL2.EXE Recover option.

Since Symantec publishes all three programs (SQZ!, FileSave, and 
EraseProtect), please be assured that we are aware of the problems and are 
looking towards a software solution;  however, until a permanent fix is 
developed, there is a workaround.

Create a DOS batch file named 123.BAT and place it in one of the 
subdirectories designated in your DOS path statement.  123.BAT's ultimate 
purpose is to start up 1-2-3, but it will also make sure that SQZ!'s .WK! 
files get saved without incident.  The first line in the batch file should 
turn off FileSave or Erase Protect.  The second line should change you to the 
1-2-3 subdirectory.  The third line should launch 1-2-3.  The fourth line 
should turn back on FileSave or EraseProtect.  For instance...

123.BAT for FileSave Ä             123.BAT for EraseProtect Ä
CD\123                             CD\123
FILESAVE /OFF (or FS /OFF)    EP /OFF
123                                123
FILESAVE /ON (or FS /ON)      EP /ON

If you are still experiencing problems, please contact SQZ! Technical Support.











SQZ! Application Note        Rev. 6/92           #7102     Page 1 of 1