Supress Save 'XYZ' with references to unsaved documents message

piers_morgan

New Member
Joined
Sep 3, 2003
Messages
20
Hi all,

I have an annoying problem that must not be present for a file I am making for end users with little Excel expertise.

I have a file that copies a worksheet from it to another workbook. If the user saves the originator file (the file from which the worksheet was copied from), the dialog comes up as below...
Save 'XYZ' with references to unsaved documents message?

Clicking OK is all that is required. But this will confuse end-users and looks unprofessional.

I tried application display alerts false at BeforeSave. Breaking links via VBA. Nothing works. It doesn't matter whatsoever if it's saved with such references, based on how these files get used. So I don't understand why MS has made this one so difficult!

Any help much appreciated!

EDIT: I also tested the worksheet that gets exported by remove all formula and all VBA code. Same issue.
 
Last edited:

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Watch MrExcel Video

Forum statistics

Threads
1,123,518
Messages
5,602,138
Members
414,505
Latest member
quoctrungvu99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top