XL: Title Bar Name Not Changed If Saved During In-Place Edit

ID: Q111806

5.00 7.00 WINDOWS kbusage

The information in this article applies to:

SYMPTOMS

In a Microsoft Excel worksheet, when you use the in-place editing feature to edit an embedded object and you save the workbook with a new name, the title bar does not change to reflect the new name until you close the file and reopen it.

WORKAROUND

To save a workbook that contains an embedded object with a new name such that the new name appears in the title bar, do not have the object open for in-place editing when you save the workbook.

MORE INFORMATION

In Microsoft Excel, when you double-click an embedded object that supports in-place activation, you remain in Microsoft Excel, but the menus and toolbars change to those of the application that created the object. The title bar changes to display "Object in FILENAME" where Object is the embedded object type and FILENAME is the name of the file in which the object is embedded. However, if you save the file in which the object is embedded with a new name, while the object is open for in-place editing, the title bar does not reflect this new name.

For example, if you insert an object in a new workbook that you have not saved, Book1, the title bar reads "Object in Book1" while you are editing the object in-place. If you then save the workbook while you are in-place editing the object as TEST.XLS, the title bar displays "Object in Book1" even though the workbook name is now TEST.XLS.

REFERENCES

For more information about Embedding New Information In A Microsoft Excel Document, choose the Search button in Help and type:

   OLE, creating embedded objects

KBCategory: kbusage KBSubcategory:

Additional reference words: 5.00 7.00

Version           : 5.00 7.00
Platform          : WINDOWS

Last Reviewed: September 15, 1996