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.
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.
I missed checking that... A huge chunk of the sheet was defined with a name. So that was the answer. Thank you for sticking with me on this.
ToddListon I referred to a missing defined name in my first reply in the thread, perhaps I wasn't too clear about what I meant 🙂
Thank you for marking the answer, other users with the same scenario questions will now be able to search the community to find their answer.
Have a great week!
cheers
- Yeah, I'm just new enough to the errors to not understand what should have been clear. lol
