Hi,
Just need to sort this out to avoid destroying important documents. I have an Excel workbook ("Excel 1") and want to add other Excels "Excel X" as inserted objects in Excel 1. I tried it, attached as icons, which works perfectly fine, the only issue is when closing Excel 1, it asks me whether I'd like to "save my changes made to Excel X" - and the options are "save", "save all", "don't save" and "cancel". I just assumed saving it and when I opened Excel X in its original location the whole sheet is just gray and the document seem to be destroyed. I want the inserted Excel to be unlinked with the original one.
Can someone explain how those different options work and what I should think about? Thanks.
Just need to sort this out to avoid destroying important documents. I have an Excel workbook ("Excel 1") and want to add other Excels "Excel X" as inserted objects in Excel 1. I tried it, attached as icons, which works perfectly fine, the only issue is when closing Excel 1, it asks me whether I'd like to "save my changes made to Excel X" - and the options are "save", "save all", "don't save" and "cancel". I just assumed saving it and when I opened Excel X in its original location the whole sheet is just gray and the document seem to be destroyed. I want the inserted Excel to be unlinked with the original one.
Can someone explain how those different options work and what I should think about? Thanks.