linked data

Hello All! I am using office 365 and when i insert a column into a data sheet, all the reports that I have linked get miss aligned. Is there a way to insert a column in the middle of an existing worksheet without having to go and update all the linked data reports? Any help is greatly appreciated!

Hi I have a problem with a linked file that I need to change filepath from user to user. The cell range will remain the same as it is the same document for every user but the file path will be different for every user. Is there a way I can change the filepath for the link to one that is typed...

Hi, I created a simple database to manage contacts. I then wanted it to display in excel, so i used the option in excel to "Get External Data" and selected "From Access". I pointed it to my database and pulled the data from a query i have. The problem now is that the excel file is the master...

Hoping someone can advise me. Firstly for some advice. Can I do this in excel. Secondly: how do I go about it. This is for collecting data for a non-profit org. I have a "Client Analysis" spreadsheet that collects data. 1. I would like the Carers to be able to click on a client name, this...

Excel VBA newbie looking to scrape property search results linked pages into excel. I have read a few of the articles here and viewed a few videos online to help me understand how this is done and gave it a go using this property search. The method I used was to save the webpage as a text file...

<tbody> Run ID Carrier ID % LIVE Cut Time LOADING/DONE Trailer # Bills Cut </tbody> Above is the information that is contained in each work book. I need to create a Macro that will allow me to search up to 7 days of these files. Each day of operation is saved to a new file. I need to be...

Hi Anyone else ever had this? Get an accdb file (any kind). Import it to an Excel Workbook as a Linked Workbook (Data > 'Get External Data - From Access) Data goes in. Lovely. Go to your VBE Immediate window. Query an activecell.value (or any cell value) Now hide the column / set the column...