Forum Discussion
Linking Entire Sheet to another Worksheet
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.
Thank you for responding.
Yes, I know it depends on a range name. Do you know the US CF 21 range name would not have worked when the other did work? All of the characters are correct in the stated names. There is nothing missing or added.
I don't want to use a table for two reasons. First, the information is not simply a data set, it is the final presentation of data that is being pulled from data sets. Second, the document is for aesthetics and not manipulation. It will be used by the Executives of the company to view for information only. I have played with different table styles and they don't do the job I want. If I have to turn to a query, I may, it just isn't doing what I want it to. Unlike the successful formula I mentioned above.
something is missing in your narrative, you forgot to mention if both workbooks were open or closed or if TW Cash forecast Mar 26''21.xlsx was open or closed and CF US 21.xlsx' was open or closed. Test again this time both files closed and see if both formula works.
- Ah, thank you for asking for the clarification. Originally I tried all configurations, both open, both closed, one open/one closed. And none work. I tried again just now, just in case. When closed I get the full file extension built into the formula, and double checked to make sure that was correct as well.
it should work when both files are opened or closed, here's a sample screen shot of one that works:
look at the formula bar
- Ah, yes. I see what you are sharing. And I see how the formula works there. Thank you.
The difference with the formula you shared and what I shared is the specific cell references. You have here an external reference to a workbook->worksheet->specific cells. I am trying to just reference Workbook->worksheet without the cells. I want the entire worksheet. And like I mentioned above, I got it to work with one workbook and worksheet, but not the other. I don't know why only one is working.
I can get it to work when I reference specific cells. It works every time. As soon as I try to only reference the worksheet in the US CF 21 workbook, the formula no longer works.