linked data

  1. R

    Insert a column with out messing up 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!
  2. O

    Link source change

    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...
  3. R

    Access opens up as Read-Only

    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...
  4. B

    Open new doc, collect data and save as separate file while remaining linked to original

    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...
  5. S

    Scrape website property search results linked pages into excel (PC or MAC)

    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...
  6. J

    How to search for specific data from several workbooks and import to one sheet.

    <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...
  7. ClimoC

    Linked Tables issue

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top