Re: I have a #REF error on one PC but not another

Ok, I found a solution!

As I kept digging there was a clue that I did not include in the sample file: the tables behind the named ranges are populated by Power Query. I tried deleting and recreating the queries. It worked for one named range, but not the rest. As I was trying to further narrow down the issue, I saw that when I tried referencing the named range there was a new duplicate named range with an _xlpq prefix. Searching that up I found https://answers.microsoft.com/en-us/msoffice/forum/all/has-anyone-noticed-xlpq-calc-errors-in-excel-when/7a3ed92e-faf5-4ba9-bb7a-67fc7cfcd3dd.

I went back and updated the name of all of my queries to be unique, and everything is now working!