Renamed File
I have 2 workbooks One is a "master" which updates the "public" file. I used
the public file and saved it as another name. Now when I open "Public 2" it wants to update which is fine. I say Ok it updates from the master but also wants to update from the original "Public" file. I have searched through the entire workbook and the Macros and can not find any reference to the original "Public" file. How can I correct this? |
Renamed File
goto www.bmsltd.ie there's a whole bunch of very nice addins there. start with Bill Manville's findlink my guess you'll need need Jk Pieterse's Name Manager too. as there might be a name object still referencing it. problem is.. names can be hidden. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Dan wrote : I have 2 workbooks One is a "master" which updates the "public" file. I used the public file and saved it as another name. Now when I open "Public 2" it wants to update which is fine. I say Ok it updates from the master but also wants to update from the original "Public" file. I have searched through the entire workbook and the Macros and can not find any reference to the original "Public" file. How can I correct this? |
Renamed File
DUDE!!!!!!!!!!!! SWEET!!!!!!!!!!!!!!!!!!!!!!!!
"keepITcool" wrote: goto www.bmsltd.ie there's a whole bunch of very nice addins there. start with Bill Manville's findlink my guess you'll need need Jk Pieterse's Name Manager too. as there might be a name object still referencing it. problem is.. names can be hidden. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Dan wrote : I have 2 workbooks One is a "master" which updates the "public" file. I used the public file and saved it as another name. Now when I open "Public 2" it wants to update which is fine. I say Ok it updates from the master but also wants to update from the original "Public" file. I have searched through the entire workbook and the Macros and can not find any reference to the original "Public" file. How can I correct this? |
Renamed File
Bill Manville is in the process of moving to a new address:
http://www.oaltd.co.uk keepITcool wrote: goto www.bmsltd.ie there's a whole bunch of very nice addins there. start with Bill Manville's findlink my guess you'll need need Jk Pieterse's Name Manager too. as there might be a name object still referencing it. problem is.. names can be hidden. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Dan wrote : I have 2 workbooks One is a "master" which updates the "public" file. I used the public file and saved it as another name. Now when I open "Public 2" it wants to update which is fine. I say Ok it updates from the master but also wants to update from the original "Public" file. I have searched through the entire workbook and the Macros and can not find any reference to the original "Public" file. How can I correct this? -- Dave Peterson |
All times are GMT +1. The time now is 09:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com