User Not Prompted To Update Links In Excel 2007 Notification Enabl

T

TrainerSW

Hello,
We are in the process of running a pilot group that is testing Office 2007.
One of our Excel testers has come across a problem related to linking to
external content. In the Excel 2003, the user was prompted to Update Links
when loading this spreadsheet - this no longer happens.

These are steps that we have taken to resolved:
-We have already selected the "Ask To Update Automatic Links" checkbox.
-We have already edited the start up and indicated that user will decide to
update links.
-We have also gone into the trust center settings, under External Content
and indicated that we wanted to Prompt User for automatica update for
Workbook Links
-We also tried opening all of the source files and then opening the workbook.

From what I have read, this should work. Any ideas?
 
J

jbil71

I am having the same issue with excel 2007. Manually selecting each linked
cell and hitting enter seems to update the values but this is not an ideal
solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and Paste Special in Excel #REF error 1
User is not prompted to update links when opening spreadsheet 2
Prompt user on automatic updates for Workbook Links 0
Linking data in MS Word into Excel 5
NAME error in excel 2010 0
Update OLE Links in Powerpoitn from Excel 0
Update Links 2
Copy Website Tables into Excel 2007 Spreadsheets 4

Top