66 votes28 comments · Excel for Windows (Desktop Application) » Opening and Saving Files · Flag idea as inappropriate… · Admin →
Thanks for taking the time to suggest this! We think having more control over how your pinned files are sorted is a great idea, but we won’t be able to address it in the near future. We’ll keep tracking the voting, though.
-SharonAnonymous shared this idea ·
30 votes3 comments · Excel for Windows (Desktop Application) » Opening and Saving Files · Flag idea as inappropriate… · Admin →
Thanks for your suggestion! Unfortunately we will not be able to address this in the near future. We’ll keep tracking the voting.
The reason you can’t have 2 workbooks open with the same name is due to the way that linked workbooks are managed. If you have multiple workbooks open and you create a link between them, Excel shows the filename of the linked file. If there are 2 workbooks with the same name, then the formula would be ambiguous. You can read more about how Excel manages external links here – https://support.microsoft.com/en-us/help/328440/description-of-link-management-and-storage-in-excel.
An error occurred while saving the commentAnonymous commented
I agree. I have wanted this ever since I switched from Lotus 1-2-3 to Excel (1994?)Anonymous supported this idea ·