I have two workbooks with linked cells that have been saved numerous times for over a year without problem. Today I open up my one sheet and there are a lot of #NAME? errors for some of those linked cells. The formulas for those particular cells all look similar to the one below. Where the word “Rent” is there should be a cell number so that the value of that cell shows up. The only way it’s allowing me to edit correctly is to manually change every single one.

The only way I’ve ever linked these is by inputting = then double clicking on the appropriate cell and the value shows up and the sheets are linked. I cannot do that anymore. The “formula” always pops up with a word in it (related to the horizontal line but not exactly the same) not the cell number.

I’ve now spent 3 hours working with online support to be told that my content is the problem and now I must manually enter all of these values. I don’t believe this as my content didn’t change and other values on the same sheets were linked the exact same way without problem.

I’m not a computer person, I’m learning. I’m a hairstylist just trying to keep my bookkeeping up. Please, any response needs to be as if you’re speaking with a 5 year old as I do not understand tech well at all.

='[Budget 2024 .xlsx]January’!Rent               should be ='[Budget 2024 .xlsx]January’!$h$86

​I have two workbooks with linked cells that have been saved numerous times for over a year without problem. Today I open up my one sheet and there are a lot of #NAME? errors for some of those linked cells. The formulas for those particular cells all look similar to the one below. Where the word “Rent” is there should be a cell number so that the value of that cell shows up. The only way it’s allowing me to edit correctly is to manually change every single one. The only way I’ve ever linked these is by inputting = then double clicking on the appropriate cell and the value shows up and the sheets are linked. I cannot do that anymore. The “formula” always pops up with a word in it (related to the horizontal line but not exactly the same) not the cell number. I’ve now spent 3 hours working with online support to be told that my content is the problem and now I must manually enter all of these values. I don’t believe this as my content didn’t change and other values on the same sheets were linked the exact same way without problem. I’m not a computer person, I’m learning. I’m a hairstylist just trying to keep my bookkeeping up. Please, any response needs to be as if you’re speaking with a 5 year old as I do not understand tech well at all. ='[Budget 2024 .xlsx]January’!Rent               should be ='[Budget 2024 .xlsx]January’!$h$86  Read More

​