External data does not auto update in excel 2010

Microsoft Office 2010 professional
March 9, 2012 at 09:34:48
Specs: Windows XP
External data does not automatically update in excel 2010. I have several workbooks linked together to share data (several log workbooks and one master workbook). When I open the master workbook in Excel 2007, the data updates automatically as it should. However, when the same file is opened using Excel 2010, it prompts me to update the data rather than updating it automatically. This wouldn't be a big problem except for the fact that the worksheet that is viewed when the master file is opened is a pivot table. When I select the update, it updates the data in a hidden worksheet but the pivot table does not refresh unless I do it manually. Most of the users that are viewing the master workbook are not familiar with pivot tables and do not understand this. The "Enable all data connections" and "Enable automatic update for all workbook links" are both selected in the External Content settings.

See More: External data does not auto update in excel 2010

Report •

#1
March 10, 2012 at 07:19:19
I'm not at all sure abut this, but the only thing that comes to mind are
The DDE settings in the Advance section of the Options menu under the General Heading
and
the Save External Link Values, also in the Advance section of the Options menu under the When Calculating this Workbook heading.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question