Deleting links to Access when e-mailing workbook

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
 
B

BrianB

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
 
J

Jonathan Rynd

[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
 
Top