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.
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?
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
- Separate the logic I would say: presentation is a different process than getting in the data. So get the data in using a query (into a table or directly feeding a pivottable or whatever you need), then use other techniques within the file to create a nice presentation sheet.
- Okay, thank you for the recommendation.
