Error on Refresh All

Question

I have a multi-tab Excel sheet where I use several tables, pivot tables with single data source and 4 pivot tables that use three data sources and these three are the only sources that show under the Active tab on the field list. Under the All tab on the field list there is a table listed that I no longer use and have deleted from the workbook. When I do a Refresh All I get this attached error. This table/data source has been deleted. How do I get rid of this error?

Answer 1

Hi jrstamps

I am Vijay, an Independent Advisor. I am here to work with you on this problem.

You need to break this link. Take a backup of your workbook.

The best way to handle links in Excel is free Add-in - FindLink of Bill Manville. In fact, this is the only add-in in my Excel. This handles all kinds of links. Finds all hidden links as well and you can break them easily.

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

If you don't want to use add-in, use below article for finding links (This article doesn't take care of Conditional Formatting links which you will have to do manually. Findlink add-in takes care of this)

https://support.office.com/en-ca/article/Find-e...

Do let me know if you require any further help on this. Will be glad to help you.

Answer 2

Hi, jrstamps

My name is Maritza and I am an Independent Advisor. I would be happy to help you today.

Try to repair Office.

https://support.microsoft.com/en-us/help/276934...

https://support.office.com/en-us/article/repair...

Let us know if these steps help you to resolve the issue.