Import Excel data forcing links (ie workbooks) to be updated

Asked Jul 01 '14 at 07:19

Active Nov 14 '14 at 14:19

Viewed 247 times

We have noticed importing data from an Excel spreadsheet doesn’t update links.

The problem with this is if you import a spreadsheet that comprises of linked workbooks data and those workbooks have been updated then stale data ie NOT the latest) is retrieved.

enter image description here

Opening workbooks using the Excel Object Model does support a parameter to UpdateLinks.

enter image description here

Is there an undocumented way to force Mathematica to open spreadsheets and update the links?

Import["c:\\temp\\Exercises.xlsx",{"Sheets","Sheet1"}][[1;;18;;1, 1;;16;;1]];

edited Nov 14 '14 at 14:19

asked Jul 01 '14 at 07:19

WolframFan

1,412
14
21

3

You can open the spreadsheet using the object model from within Mathematica e.g. Open Excel file with Mathematica - you will have to add the update command. Please post your solution here for future reference. – Chris Degnen Jul 01 '14 at 07:48
2

Another option is to create a VBA script that update your xlsx file, and than you can import it. you can use Run command to run the script. – Murta Jul 01 '14 at 21:46

Import Excel data forcing links (ie workbooks) to be updated

0 Answers0