Microsoft KB Archive/134618

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

PSS ID Number: 134618

Article Last Modified on 10/22/2000

-

The information in this article applies to:


 * Microsoft Excel for Windows 95 7.0

-



This article was previously published under Q134618



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.

