Excel 2000 SP3 - Turning Off Automatic Updates



I need to find a way to turn off external link references for Excel 2000.
The OIG Auditor has requested all data requests in electronic format. There
is no way to override the automatic update links (why?) - tool, options,
calculations, clear update remote references doesn't work - (again, why?).

Can a VBA script be created so the auditor is view REF#, VALUE#, etc., or
clicking cancel thousands of times because the spreadsheets cannot find the
referenced remote files?


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question