Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 503
  • Last Modified:

Excel 2007 not updating external links

I have an excel workbook with links to external workbooks. I have set links to update automatically and have verified that all the links are ok but they still dont update until I have opened the other workbook. Anybody know how to fix this?
0
JonMny
Asked:
JonMny
  • 5
  • 5
1 Solution
 
SiddharthRoutCommented:
I might be off the mark but is the external workbook a 2003 version? If yes, then try saving it as 2007 and then retry it.

Sid
0
 
JonMnyAuthor Commented:
All workbooks are 2007.
0
 
SiddharthRoutCommented:
Though you have mentioned it above but just to reconfirm you have done the following?

1) Office Button, bottom right, -Excel Options
-Trust Center
-Trust center settings
-External content
-security settings for workbook links
"enable automatic updates for all workbook links" is Active

2) The ribbon under the quick access toolbar: Data tab - connections group - edit links - update shows a selection of automatic or manual?

Sid
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
JonMnyAuthor Commented:
I didnt have the external content set but still not updating

 
0
 
SiddharthRoutCommented:
Hmmm. That is strange.

Ok when the external workbook is closed, go to any cell which has a link on your main workbook and press F2 and then press enter. Does it update the workbook?

Sid
0
 
JonMnyAuthor Commented:
0
 
SiddharthRoutCommented:
JonMny: No that article is not applicable to this as you are not using an earlier version.

Does this happen with specific files or happens with all linked files?

Sid
0
 
JonMnyAuthor Commented:
yes, not sure if it matters but the cells that it's linked to are also formulas.
0
 
JonMnyAuthor Commented:
If I open any of the linked files first and close excel then open the main workbook the links do update.
0
 
SiddharthRoutCommented:
>>>not sure if it matters but the cells that it's linked to are also formulas.

No that doesn't matter. Pressing F2 should have updated the formulas anyways. But as per your post ID: 35150237, F2 also doesn't work.

Does this happen with specific files or happens with all linked files? on your pc.

Sid
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now