Hm I think a lot of those named ranges aren't used.
What I'm thinking as far as the changes was just to push a new excel spreadsheet out to people and they would click the button to bring in all of their project data (those date tabs). I'm not sure if this is what you mean by changes. I will be continuing to optimize this workbook so eventually when version 4 comes out, I want people to be able to make a really easy transition ( a lot of people don't know or would have a ton of trouble copying sheets and updating the values to get rid of links)
Sorry about the ambiguity of my question. I meant to ask what you meant by:and how you go about locating the reference and changing it. Also, I'd recommend copying rather than moving sheets since I noticed that removing sheets from the workbook will cause reference errors in the Chart-Data sheet and probably the Project-Chart sheet as well.- The reference is to the sheet location C://
If your question has been satisfactorily addressed, please consider marking it solved. Click here to see how.
Also, you might want to add to the user's reputation by clicking the scales icon - it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
So to duplicate the problem/situation you would simply make a copy of this workbook, then try to copy the date tabs into it.
By the reference I was saying that when I copied excel had "external references" to the workbook I copied from. So it was referencing the workbook on my c drive that I copied the data from.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks