Deleting links to Access when e-mailing workbook

  • Thread starter Thread starter Jeff Tillack
  • Start date Start date
J

Jeff Tillack

Goodmorning,

I have a large excel based application which uses links
back to an Access DB to refresh/store all new data. When e-
mailing this workbook to end users several messages appear
asking about links etc. Is there a way to ensure the users
don't get these messages when I email the workbook to
them? In other words, I need the workbook to be a stand
alone app, without looking for links back to the database.
As my directors are PC illiterate I have to make things as
easy as possible for them.

Any urgent help would be fantastic.

Jeff Tillack
Information Resource Officer
Information services Branch
Dept of Families
Brisbane, Australia
 
It means making a separate copy of the workbook where you Edit/Copy th
sheets and then Paste Special/Values.

This effectively removes all links/formulas
 
[posted and mailed]

I have a large excel based application which uses links
back to an Access DB to refresh/store all new data. When e-
mailing this workbook to end users several messages appear
asking about links etc. Is there a way to ensure the users
don't get these messages when I email the workbook to
them? In other words, I need the workbook to be a stand
alone app, without looking for links back to the database.
As my directors are PC illiterate I have to make things as
easy as possible for them.
Click to expand...

Use the add-in FINDLINK.XLA to detect and remove all links to other files.
http://www.accountingadvisors.com/download/findlink.exe
 
Back
Top