I am using the CountCcolor function in a shared spreadsheet (on a network). It works just fine when I have it open, however when anyone else has it open the get a name error. Excel (2016) wants to update a link, but will not. What do I need to do so that this works on the other desktops as well.
The function still works in an older spreadsheet, but in this new one (which is just copied and renamed) it would not work. Suggestions?
This what the other desktops see when trying to update the link: 'C:\Users\sundberc\AppData\Roaming\Microsoft\AddIns\2019 Qtr 3 Yellow OT.xlam'!CountCcolor(F7:AJ7,$I$3)+B7
they should see =CountCcolor(F7:AJ7,$i$3)+B7
Bookmarks