If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site. Hi I am having issues with updating links in Power Ppoint to Excel tables/charts. When setting up the link I am using Paste Special - Paste link - Microsoft Excel Worksheet Object.
If someone is in the data entry workbook, when the analysis workbook tries to refresh the external data it opens a read only copy of the data workbook and makes it your active workbook. Alright, it looks like if the data workbook is closed, the analysis workbook external data query works just fine.I'm pulling together a couple of spreadsheets for an event this weekend, and i've got pretty much everything dialed except one key piece. One is where data is keyed into, the other is the data analysis spreadsheet.I've got the information from the data entry sheet pasted as a link into the analysis spreadsheet and that part works great.I thought if I had calculate upon saving turned on and set autosave to save every couple of minutes, that the links would automatically refresh, but they don't.Autosave with calculate upon save turned on saves the information that is in the analysis spreadsheet, but doesn't update newly saved data from the data spreadsheet.
I have checked and in the link the option is ticked to update automatically.