Hello,

I am trying to help a colegue out with her workbook. She has one spreadsheet that is updated based on data entered on another spreadsheet and it works great but we are trying to add more columns and the formula isn't working for all of the cells. It is showing the formula and not the data. Some cells are working but not all of them and I can not figure out why....

Example:

Sheet1 is the spreadsheet that is updated and Sheet2 is the one that gets updated data.

The formula that is in the working cells in Sheet2 is as follows:
='Sheet1 '!$F$2581

I use the same formula updating cells but am getting just the formula in two of the rows....

I would appreciate any help with this.

Fran