How can remove all references to a sheet? Here's a summary of what I've tried.
- Sheet A is my Master on which I have many project tasks out to various resources.
- I made a backup of Sheet A and called it Sheet B.
- I then deleted a lot of tasks from Sheet A knowing that I had them saved in Sheet B.
- I removed sharing on Sheet B. I don't want Sheet B referenced for anything.
- I create a report intending for it to draw only on Sheet A but yet it pulls from Sheet B as well.
What am I missing?
Thank you,
Holly.
