linked

I have a PowerPoint with many slides that have charts linked to data in Excel. Periodically the excel data will be updated - instead of manually going through each slide, selecting each chart, and selecting "Refresh Data", I would like to create a macro that automatically refreshes the data for...

So I have an issue in my excel file where I have a cell that is bound with a combo box. Every time the combo box selection is chosen, the linked cell will, of course, automatically contain the contents of the combo box. I then want my VBA script to automatically open an excel file on my desktop...

So I have an issue in my excel file where I have a cell that is bound with a combo box. Every time the combo box selection is chosen, the linked cell will, of course, automatically contain the contents of the combo box. I then want my VBA script to automatically open an excel file on my desktop...

Hi All, my excel workbooks are set up in such a way that they are not linked to each other, i.e.if I open up two workbooks and try do vlookup across the two, it does not work. could you please advise how to fix it? thank you

I want to have different formatting for cells containing links. The data includes formulas like "=300+45*5", text as well as linked cells. I want to have only the linked cells show in a different colour. Any suggestions?

Hello everyone, I am working to create a Powerpoint that has many linked cells from an Excel workbook (like 100+). Whenever I click "update links" when opening the PowerPoint, the cells all shift slightly and they also cut off so you can only read half of the cell. Originally, these pasted and...

I have a linked table in a local Access (2010) database. This linked table contains a table that's connected to an XML file on the server. The reason why I have it set up this way is because from my understanding, Access does not have the ability to create a link to an XML file. In any case...

Hi, I have created a User DSN and successfully created a linked table in Microsoft Access with that DSN, however through excel vba when I tried to fetch data from that linked table an error message is displaying "ODBC --connection 'SERVERNAME' failed. However I am successfully able to fetch...

Hi, I have a linked table in ms-access which is linked to a sql server table, and when I am trying to fetch the data in excel via VBA from ms-access linked table the error message "ODBC connection failed" showing. Note:- I am manually successfully able to refresh ms-access linked table in...

Hello, and thank you in advance for helping if you can, I have created and Access database, and I am trying to link to some of the queries from it in Excel's Power Query. In the get and transform, I can see the database, all of the linked tables, and one query I had created for a union query...

Hello, and thank you in advance if you can help, I have a database that I am trying hard to not create physical tables in. I have two linked tables to the database, call them data 1 and data 2. I would like to create a query that will append these two tables together according to the fields in...

Please let me know if I can link Word documents in an Excel cell with relative addressing instead of absolute addressing. I like to be ab;le to save the Excel file and all linked Word files in one folder such as My Document and send them all to other recipients via email and for them to be able...

I have a workbook with cells linked via copy and paste link. Thing is when cells are blank the corresponding cells that linked to they are showing as "0". Is there anyway I can stop this happening.

Hi, I'm encountering an unusual problem. I have cells in workbook A with links to cells in Workbook B. When both workbooks are open, everything is fine. But if I close workbook B, the linked cells in workbook A change to an #value error. If I reopen workbook B, the error goes away and the...

Hi, I have a MS-Access database and in this database there are around 20 tables, and 5 tables from 20 are linked from SQL Server Table through ODBC connectivity. Now I want to fetch the result of a SQL Query and paste that result in a excel sheet. Note:- the query is taking a reference of a...

I have created a master spreadsheet with links to four other spreadsheets which shows the correct results when all linked files are open. However, if I open the master spreadsheet alone the linked cells show #VALUE ! rather than the value. In case this is relevant the linked cells are a "SUMIF"...

Happy Friday, everyone! I am working on code that will help me set up different Front Ends to different Back End tables without manually importing tables or using the Linked Table Manager. I have already figured out how to automate the import and relinking functionality, but now I want to add a...

Good Afternoon Mr. Excel, I'm hoping someone can help me on here. Have a good knowledge of excel & have been using it for years. I'll explain what I'm trying to do. Would like to open an excel workbook and see a calendar. This calendar will be linked to a single "sheet". I would like to apply...

OK, so, I need to tap some excel wizardry on this. I want everything (menu bar, tools, ribbon, the works) hidden. I only want the cells and maybe a scroll bar to be seen. I linked an image of what I imagine it to look like...

I have a database with Linked Tables. The database has multiple users, some with little access skills. Is there a way to automate the updating of the Table Links? Some people are untrainable? lol