Forum Discussion
Solved
Linking Entire Sheet to another Worksheet
Hello, I am trying to externally link an entire spreadsheet to another spreadsheet. Example: I want all of the data on Sheet1 to be on Sheet2. I also want Sheet2 to auto-update when Sheet1 does. ...
You stated: I get the #NAME? error.
check this place:
check the name manager, maybe the range for the formula that worked is defined there, while the other is not.
The formula depends on the presence of a range name in the workbook you are linking to.
If I may ask: What is wrong with having it in a table? Tables have huge advantages. Do you know you can change the formatting of the table by choosing a different table style?
If I may ask: What is wrong with having it in a table? Tables have huge advantages. Do you know you can change the formatting of the table by choosing a different table style?