General discussion


Office 97 Excel

By dmcelyea ·
There are several Excel files stored on an Nt 4.0 Server. This user opens one of the Excel files over the network on an Nt 4.0 Workstation. This file is not protected. When the user goes to Insert/Worksheet this option is not available. Several Excel files are this way. One of these files was opened on 4 other workstations and the same problem was encountered, so it is not machine specific. We gave this user the idea to create a new Excel file and copy and paste all the data. After this was done the user could insert/worksheet easily.
Is there any way to correct the corrupt file which will allow the user to insert/worksheet without going the long way around creating new files?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Office 97 Excel

by heavyduty2 In reply to Office 97 Excel

I would make sure that the stored copy of the file is saved as the same version of Excel. Often I have seen older versions that have been kept around, or a file saved as an older version refuse some changes. Usually you will get a "Open as Read-Only" message when opening an older format in a newer version.

With a backup copy elsewhere, try opening the file and clicking FILE, SAVE AS. Make sure the "SAVE AS TYPE" entry is "Microsoft Excel Workbook (*.xls)". Use the existing name. Save.Close. Then reopen and try to insert the new sheet.

Hope that helps.

Collapse -

Office 97 Excel

by dmcelyea In reply to Office 97 Excel

User had fixed the file and said it was a dead issue. I had a copy of the corrupt file but deleted it. Appreciate the quick response. I was wanting to try your suggestion but I do not have a file at this time. I am sure it will happen again.

Thanks Very Much

Related Discussions

Related Forums