Feedback by UserVoice

Anonymous

My feedback

  1. 30 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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 comment
    Anonymous commented  · 

    Agree; I have been opening same-filenames in Lotus for almost 30 years. Example: A:\ floppy and C:\ hard drive was the original task. Why do you think/guess Excel disallows? To keep users from confusing themselves about where they are? Or a legit programming reason?

Feedback and Knowledge Base