removing external links

  • Thread starter Thread starter Joey Sark
  • Start date Start date
J

Joey Sark

i created a nifty time card calculator that rounds the punches to the
nearest 15 minutes and does all the necessary totals in one workbook.
this required the creation of a user-defined function (in VBA) to do
the rounding.

later i created an entire payroll cost management system in another
workbook. I copied the time card sheets and VBA code from the first
file to the second, and got rid of the first file.

now every time i open the second workbook file, i am prompted to
update external data (or not update), apparently refering to the
workbook where the time card and vba function were originally created.
there is no external data and this prompt confuses my users and it
really bugs me that i can't get rid of the 'ghost' external reference.

any idea what can be done about it?

thank you kindly.

Joe
 
There are two solutions I know of:

1. Do a search on each page for a square bracket '[', because any links in the cells to an external workbook uses them;

2. The links could be in the names, go to Insert | Names | Define and click on each name to check whether it refers to an external workbook.

cheers,
Isabella
 
Back
Top