link data

Hi I created a Treemapchart using excel 2016 I am trying to copy & paste the chart into a word document using the link data option however the option is not available. I want to link the chart to the word document so it automatically updates whenever I change the source data in excel. Thanks

Ok first I will apologize cause this is not just an Excel question. I have Excel workbooks linked to each other on a file share. I wan to move them to TEAMS which essentially is SharePoint on the backend. The question is how do I link sheets form one file in TEAM A to a file in TEAM B? I can...

Hello there, Hopefully everybody is fine, I have planned a lot and structured the data for many hours and days, now I would like to know how I can link excel cell value of workbook1 to workbook2 in the case that they are in google drive because when I opened the other workbook is shows a...

Hi All, I have a workbook that contains 2 worksheets. One worksheet is the supplier inventory data, titled ("Rugs") and the other worksheet is what I use to import into my website, and it's titled ("Store"). What I do, is I link each cell of data from the ("Rugs") worksheet to the cells in...

I am trying to write VBA which will allow dynamic excel ranges to be exported to (possibly) an intermediary file (open-minded about file type) and for these ranges to then be linked to a PowerPoint presentation. Currently, the intermediary files are PNG pictures but the print quality of the...

I have a dashboard in a workbook that displays a number of charts that have their data stored in a different workbook. This is so that we can update the data upon demand and independently of the dashboard (as it may have a number of concurrent viewers). It works pretty well on the whole, but...

Good morning all... I have an issue that hopefully someone can lead me in the right direction on. I am trying to simplify the managing of data throughout many workbooks. I would like to have a data worksheet in a source workbook that links to other data worksheets in their respective...

Is there a way to use data from a file that has been updated with a different name on the server? Location stays the same, but the name changes somehow. for example: location: G:\...\Quality\data\brackets_26-04-2016.xlsx after _ :date will be changed So there is a possibility there are...

Good Morning. I am currently working on a tool, where I have a Macro in place to clean up and extract unnecessary data. What is left, I want to be able to pull key cell info and place it in a table on a separate sheet. - The data as well as cell location will not be the same each time - There...