Links updating screwed up my spreadsheet!

nyc2pdx

New Member
Joined
Sep 2, 2021
Messages
5
Office Version
  1. 2016
Platform
  1. Windows
I have a workbook with several data pages, one for each client and hundreds of lines of data for each. I created a summary page to automatically pull the data I need into a single sheet. I am using a lot of Countif and Countifs as I need to know the number of times Yes or No appears in a column. It has worked pretty well.
Today I got a message about updating my links. I clicked update, and now none of the links to the other sheets work. The formulas have not changed, and when I click on it, it highlights the right sheets, but returns no value. For example, On my summary page, I have a formula entered: =countifs('CompanyA'!$A:$A,Summary!$B3,'CompanyA'!D:D,Summary!$C3) Summary B3 = July, and there are 15 instances of July appearing on sheet 'CompanyA' column D:D. But it returns zero. Not sure why this is happening. Help? Everything was working fine until this external update happened.

Thank you!
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

earthworm

Well-known Member
Joined
May 19, 2009
Messages
618
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Update links appear when you link formula with another workbook located at different location / same location. Try locating those sheet . If you still cant find then it wont work. otherwise you need to map formula located in same workbook only.
 

nyc2pdx

New Member
Joined
Sep 2, 2021
Messages
5
Office Version
  1. 2016
Platform
  1. Windows
That’s the challenge. All the links I programmed in point to other sheets in the same workbook. Nothing outside the workbook. I simply have a summary page as my first worksheet and then about 30 worksheets after it that the summary page references.
 

earthworm

Well-known Member
Joined
May 19, 2009
Messages
618
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
If the data is appearing on other sheets and summary not working then just try to map just one formula and check whats happening
 

nyc2pdx

New Member
Joined
Sep 2, 2021
Messages
5
Office Version
  1. 2016
Platform
  1. Windows

ADVERTISEMENT

okay. When I delete one of the formulas, and then re-enter it on the summary page, still pulls nothing. No error either.
 

earthworm

Well-known Member
Joined
May 19, 2009
Messages
618
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
check if auto formula on is selected on workbook.
 

nyc2pdx

New Member
Joined
Sep 2, 2021
Messages
5
Office Version
  1. 2016
Platform
  1. Windows
I figured it out. My assistant added a space after the month name. It was looking for the month name without a space.

argh. Thank you @earthworm for your help! So appreciated!
 

Forum statistics

Threads
1,147,498
Messages
5,741,504
Members
423,663
Latest member
kaveh87rsh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top