always enable content when opening

americanpie3

Board Regular
Joined
Jul 16, 2003
Messages
180
I have excel sheets that cross link with each other. I've just migrated to Office 2007. When I open my excel sheet I always get the question at the bottom of the tool bar Security Warning Data connections have been disabled. And then I have to click on option and enable content.

My question is, how do I always enable the content?

Thanx
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

iliace

Well-known Member
Joined
Jan 15, 2008
Messages
3,542
You can find these settings under Excel Options -> Trust Center. Click on Trust Center Settings button, then under External Content choose the Enable All Data Connections option.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,491
Messages
5,468,926
Members
406,620
Latest member
Gitani123

This Week's Hot Topics

Top