How to stop "This workbook contains external data..." message

ardykav

Board Regular
Joined
Oct 18, 2015
Messages
172
Office Version
  1. 365
Platform
  1. Windows
Hi,

I have looked on a few forums and cant seem to find the answer to this. I was sent a CSV and when i changed it to a macro enabled workbook I keep getting this message every time I go to save it, how do I turn it off permanently? Also there are no options in the connections or edit links area making it look like there isnt any external links and there are no named ranges specified

External.jpg
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
The external data can be in
  • formulas (visible through Data --> Edit Links)
  • named ranges
  • macros called by buttons and shapes
  • conditional formatting
  • pivot tables linked to external sources
Download this link from Bill Manvilles site to help find and remove them
 
Upvote 0
Thanks but its not in any of those as it was a flat CSV file first then i made a pivot table from that CSV and that is all that has been done to it
The external data can be in
  • formulas (visible through Data --> Edit Links)
  • named ranges
  • macros called by buttons and shapes
  • conditional formatting
  • pivot tables linked to external sources
Download this link from Bill Manvilles site to help find and remove them
 
Upvote 0
The findlinks addin is awesome by the way, thanks for that. However it also said that there was no links there.
 
Upvote 0
You can also try
select Edit Links in the Queries & Connections group on the Data tab>>Click Startup Prompt.>>Click the Don't display the alert and don't update automatic links option.
 
Upvote 0
I figured it out and my sincere apologies. I had the file saved as Macro Enabled Workbook template. Apologies

You can also try
select Edit Links in the Queries & Connections group on the Data tab>>Click Startup Prompt.>>Click the Don't display the alert and don't update automatic links option.
 
Upvote 0
Sorry for joining this conversation however, my problem prompted me to ask how to solve it
Somehow or other when I open excel 2016 I get this message
1590732481641.png

When I click OK it disappears.
How can I get rid of this message at startup1590732481641.png
 
Upvote 0
Sorted.
It was connected with Mr Excel xl2bb.xlam and in trying to locate the file in my system came across the offending file by removing the xl2bb from add-ins.
That gave me a prompt whether to delete or not and i deleted and problem solved.
Now i need to see if I can download the add-in
Thanks to any who looked to help
 
Upvote 0
@pedro-egoli
I initially had the same problem with XL2BB, I deleted the original download and used the latest version with no issues.....HTH... (y) (y) (y)
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,636
Latest member
laura12345

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