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

[ardykav]

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

 

[Michael M]

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

• FindLink

 

[ardykav]

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

• FindLink

 

[ardykav]

The findlinks addin is awesome by the way, thanks for that. However it also said that there was no links there.

 

[Michael M]

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.

 

[ardykav]

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.

 

[Michael M]

As long as you got it working...

 

[pedro-egoli]

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

When I click OK it disappears.
How can I get rid of this message at startup

 

[pedro-egoli]

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

 

[Michael M]

@pedro-egoli
I initially had the same problem with XL2BB, I deleted the original download and used the latest version with no issues.....HTH...