New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Excel will not Auto Refresh external data when opening file

Macros, VBA, Excel Automation, etc.

Excel will not Auto Refresh external data when opening file

Postby AFSkier » Tue Dec 20, 2011 1:53 pm

How come Excel will not Auto-Refresh external data when opening file on all PCs? Only 2 of 5 PCs in our office will Auto-Refresh the data when the Excel file is opened. It is that way with all Excel file with external data connections. All of the PCs can manually refresh the data. All are nearly identical, running Windows XP & Excel 2007.

The Connection Properties for the file is set to "Refresh data when opening the file". Yet only 2 of 5 PCs will Auto-Refresh on open.

I've checked all PCs to make sure the Macro Settings are set as follows:
*Macro Settings: Enable all macros
*External Content: Enable all Data Connections
*External Content: Enable automatic update for all Workbook Links
  • 0

AFSkier
Rookie
 
Posts: 1
Joined: Dec 20, 2011
Reputation: 0

Re: Excel will not Auto Refresh external data when opening f

Postby Don » Tue Dec 20, 2011 10:29 pm

Do you have any anti-virus programs that may be affecting it? For instance, I run pretty strict access controls through my anti-virus program and this prevents some functionality in MS Office from working until I tweak a setting or two in the anti-virus program.
  • 0

Don
Moderator
 
Posts: 733
Joined: Dec 4, 2011
Reputation: 2
Excel Version: 2010


Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 241 guests