(While referenced file is still in protected view): 'Enable Editing' only in linked file.Open the other file that is being referenced (remain in Protected View for this file too). Open file (in directory that is not listed as a Trusted Location) containing links, remain in Excel's Protected View ( don't click Enable Editing).To be explicit, I have replicated the following issue: "#REF" replaces "Sheet" in formulas to an external workbook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |