Refresh data link without prompting when file opens?

dwilliamson1024

New Member
Joined
Dec 8, 2014
Messages
40
I have a large metrics Excel 2013 workbook with a lot of hidden tabs with data links pulling data into tables. I have a handful of these set to refresh upon opening the file...which causes a warning upon opening the file to update links or not. Can this warning be turned off so the user doesn't have to decide to click yes or no?

Thanks for any help!
Dan
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,102,288
Messages
5,485,909
Members
407,523
Latest member
Talicius

This Week's Hot Topics

Top