XL7: No Changes After "Save Resulted in Changes" Message

ID: Q134618

7.00 WINDOWS kbnetwork

The information in this article applies to:

Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, when you save a shared file, you may receive the following message:

   Save resulted in some changes from other users

When you choose OK, the file you are editing may not display any changes.

CAUSE

This behavior occurs when another person adds a formula to a shared file and saves the file while you are editing the same file. For example, if another person opens the shared file you currently have open, adds the formula =SUM(A1:A4) to cell A5 on the worksheet that you are editing, and then saves the file, you receive the message described above when you save the file; note, however, that the change to cell A5 does not appear on the worksheet that you are editing.

This behavior occurs because although formulas are not saved in shared workbooks, Microsoft Excel determines that another person made a change to the file and informs you of this change, even though the change is not saved. Note that this behavior does not affect the functionality of the shared file. However, it may be confusing if you notice that no changes appear in the file after you receive this message.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

When you add a formula to a shared workbook, you receive the following error message:

   New or copied formulas cannot be saved while the file is being shared.
   Show this message in the future?

When you save the file, the formula still appears on the worksheet on your computer. However, the change does not appear in the worksheet on any other computer where the shared file is currently open. Additionally, when you close and then open the shared workbook again, the formula no longer appears.

REFERENCES

For more information about creating a shared list in Microsoft Excel, click the Index tab in Microsoft Excel Help, type the following text

   shared lists

double-click the selected text and then double-click "Create a shared list" to go to the "Create A Shared List" topic.

KBCategory: kbnetwork KBSubcategory: xlwin

Additional reference words: 7.00

Keywords          : xlwin 
Version           : 7.00
Platform          : WINDOWS

Last Reviewed: September 16, 1996