refresh external data

  1. B

    Formula range changes when linked table is refreshed

    Greetings! I have a table linked to Access, with a column I inserted into the Excel table, so I could use a formula. However, when I refresh the table, the range in the formula changes. Nothing else in the formula changes, just the range. Here is the formula as it should be: Cell T3...
  2. K

    Unable to Refresh Powerpivot when data is modified

    Hi, I've linked a data set in one workbook (multiple tabs with identical columns) to a powerpivot in another workbook using a modified SQL in the table properties 'query editor'. The powerpivot loaded all 12 tabs from the data set without an issue. However, when I change the data in the data...
  3. M

    Refresh external data on spesific date

    I have external data from a web page in one of my sheets and would need these data to be refreshed on the 1st day of each month. Currenlty I'm only able to set refresh every x minutes in "External Data Range Properties" field... Any solution to this?
  4. P

    Managing querytables, connections, recordsets

    HI ALL, FIRST OF ALL, SORRY ABOUT MY ENGLISH, IM NOT AMERICAN. I HAVE AN ADODB.CONNECTION, FROM I QUERY DATA USING AN ADODB.RECORDSET, SO I ADD A QUERYTABLE TO PASTE THIS DATA ON MY SHEET USING REFRESH. I HIGHLY WANT THAT THIS QUERYTABLE REFRESHS ALONE, SO THE DATA IS UPDATED WITHOUT THE NEED...
  5. R

    Multiple workbooks refresh from password-protected database. How to enter pwd/login just once?

    Hello, Our organization has about fifty scorecards in Excel, with three data connections apiece. All of them refresh from the same password-protected database. Is there a way to write a script that will open and refresh all the workbooks at once, wihtout having to type the login and password...
  6. L

    [PowerPoint] Refresh diagrams from Excel

    Hello guys, first off not sure if here is the place for this issue, so pls direct me if I'm on the wrong street Straigth to the point >_> I got some 80ish slides with diagrams all of which are linked to an Excel book with several spreadsheets. When I have the master excel book and the temporal...
  7. O

    refreshing source data with new columns added

    Hi, I'm new to PowerPivot, and have the following question: I build a very basic powerpivot file, which combines raw data from two excel files connected by a shared key. Now I added more columns to one of the source file (it's an export from our CRM system, so these are completely new fields...
  8. babyhime4

    Linked Workbooks + Password Protect

    The Skinny: I am trying to put together a budget planner for my company where each division has the option to give a part of their allotment to each other. I need each division's workbook to have the latest update from the others: Division1 - gives $500 to both Division2 and Division3...
  9. phildetwei

    Record time cell changes when cell is changed by formula/database refresh

    Hello all. I use the code below to record the time a cell value changes. This works good so long as the cell was changed by direct input. I have a case where it would valuable to be able to automatically record the time/date a cell was modified for cells that are changing, but changing only by...
  10. A

    MSQUERY - optimal running

    happy new year to all. I am in a quandary this morning. the organisation i am working for at present has a nasty habit of dumping information on a weekly basis into spreadsheets on the network. The business unit that I work with then adds the new data to the previous weeks and reports on a year...
  11. C

    VBA Connecting to Closed Workbook

    Hi All, I have a Data Workbook holding all data for my reports, I would like Query my this closed "Data Cube" (which is table format). But rather than build a connection through the DATA tab, I would like to use VBA? (reasons for this is i am querying a data set which is on a intranet...
  12. U

    Cancel Refresh of External Data when not connected to network

    I have a Workbook that gets data from an Access database. I have the workbook refresh this data on open. Everything works great when connected to my work network, or to the vpn. However, when I am not connected to my work network I get prompts for entering network info or to cancel the...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top