Share via

Excel - Refresh Error; updating a Connection

Anonymous
2020-06-09T12:42:50+00:00

When I attempt to refresh all data, I get a "Type Mismatch" error and notice the worksheet connection lists a File other than the one I am working in.  How do I update the Connection to be the correct one?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-06-09T12:46:07+00:00

    Hello Scott07

    I am V. Arya, Independent Advisor, to work with you on this issue. In Data tab - Edit Links - Do you see the link which you can update or remove.

    Otherwise you can use Findlink Add-int to find links in all other places like Name manager, charts, conditional formats etc.

    https://www.manville.org.uk/software/findlink.htm

    Standard Disclaimer - This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

    0 comments
  2. Anonymous
    2020-06-09T12:49:51+00:00

    Under Queries and Connections, I see a worksheet reference to an "old" (similar) file.  To create my current file, I simply removed data from the "old" file above and used as template.  Not sure if this is the root cause?

    0 comments
  3. Anonymous
    2020-06-09T17:01:59+00:00

    Does it still give the error after taking the above step?

    0 comments