Dull question of the evening.
I know how to embed an entire excel worksheet as an object but I'd like to show data from selected cells in a word document so that it automatically updates if that cell is updated?
Is this possible?
God, I hope not! What are you trying to achieve?
Why not just provide a link to the spreadsheet? I'm assuming it's hosted somewhere, otherwise it'll break as soon as you move one and not the other.
Yes. Copy the values you want and paste as an object. You have to manually refresh though
Yes tried the paste as object but what do you mean by manually refresh? Re paste it or is there a way in word to "re-call" the data from the xlsx?
(I know this will only work if the two files remain in the same shared drive location)
It's an evolving couple of documents that me and colleagues are working on so good to have 1 version of the word doc that updates as new values are entered
Manual refresh of data fields is I think either F9 or shift-F9.
But again - why? Why not just reference the data document, "for the current figures look here.
Embedding document types inside others is clunky at best, expecting live data from multiple collaborators is just... It might well be possible but there is surely a better way of doing whatever it is you're trying to achieve?
I tried to do this in a past life with multiple Excel spreadsheets, using one as a "master" lookup to populate fields in others, and it was a bloody nightmare. I quickly found myself ankle deep in VBA and eventually it mostly worked, usually. Sometimes. The final solution wound up being a LAMP server - a MySQL database with a hand-coded web front end.
Because when the evolving document needs to be shared with board directors who potentially don't have the source data sheet or shared drive access set up, I can just print to pdf and send the document knowing it's got the latest data from the excel pulled in.
Can you make a tab in the Excel look pretty enough to be the sheet you show management? As data will be in the same file it will refresh automatically.
I know it's not ideal but I hate Word at the best of times and asking it to include data gives me a headache.
Or do you have access to Tableau or Power BI. Probably overkill but you can set up automatic data refresh and can make them look pretty.
