- Joined
- Oct 18, 2017
- Messages
- 1
- Reaction score
- 0
Hello everyone. This is different than other cases I've seen here though related. Please bear with me. I have a workbook containing three sheets. I have four lines of text on the first sheet which I'm referencing in the second sheet by using for instance, ='Page 1'!A3:I3. It works well, except I've decided to add a new column to the left on the second sheet and so that pushes everything on the sheet to column B, and the new column is now A. When I do that, then the references return a value of '0'. If I remove the new column, then it fixes again. The formatting is the same (general) and calculations are on automatic. I'm confused as to what is causing that. Thank you for your help.