refresh external data

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

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

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?

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

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

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

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

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

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

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

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

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