refresh data

HI, I am using a SQL QUery to pull data into a Table, in Excel. Everything work great. However my query is about a 4 month range and I need at least 4 months of data in order for the forecasting to work properly...

I have a correctly connected query table on a worksheet called "SQL Data" that I can refresh manually no problem. However, when I run this VBA code I get the following error: Dim ws As Worksheet Set ws = Worksheets("SQL Data") 'Refresh the SQL Table ws.QueryTables(1).Refresh >>ERROR...

I have a pivot table linked to an Access Query. Until today it was working, the data would refresh OK. Today I tried to refresh and got the error message: [Microsoft][ODBC Microsoft Access Driver] Too Few Parameters. Expected 1. The pivot table will not update and I cannot figure out what...

I have a data table that includes all 2010 sales data. I have created a pivot table that draws from this data. When I add in the 2011 sales data, and change the data range for the pivot table, I don't see the 2011 data. The only way to see the 2011 data is to delete the existing pivot table and...

Team, The source data for a pivot table was recently updated. The "Month" field previously showed: Oct, Nov & Dec Now the "Month" field shows only: Jan In the pivot table, when I click on the "Month" and go to the Filter List, Oct, Nov & Dec are still there!! The data items: Oct, Nov & Dec do...

Hi I have 3 colums all with list data validation, the last 2 columns have lists that change depending on what is selected in the first column. This works fien however if a user selects something on either of the final 2 columns but then goes and changes their input on the first column the...

Hey all! I have been looking at methods to refresh data from a website where you need to login and I have seen a few ways of doing this. I know it does vary from site to site and of course my preferred method, but at this point I am looking for advice on the best possible solution to my issue...

Hello, Could anybody help with a VBA query? I am using the below code to automatically refresh a pivot table everytime cell A1 changes. The only problem is A1 is a formula and as such if the value changes the code assumes nothing has happened. Can VBA recognise cell formula changes? Private...

Hi, I have a word document with an excel graph link. When I ask to refresh the data in word the excel data doesn't refresh properly. I think this must be because excel graph doesn't have time to refresh. When I open the excel file separately it take a couple seconds for the graph to update...

I have a number of template workbooks that all connect to one database to refresh certain information. I use a refresh all command in the on open event of the workbook. The issue I am having is that when any of these workbooks are open, it locks the access database (creates the .laccdb file)...

Hi, I am a complete VBA newcomer and I have a worksheet in which I want to refresh the data in a pivot table. The data is kept in several identical worksheets. I recorded a macro to change te data which worked fine.... but I wat to be able to change the spreadsheet name by a string name: Sub...

Hi all, I am trying to populate an ActiveX ComboBox on an Excel spreadsheet with file names from a given directory. Currently I have a "refresh" button that users can click to refresh the drop-downs when they add new files to the folder. I would like to automatically do this. I have tried...

Greetings, I used a "user defined function" to reference a cell on the previous worksheet regardless of the worksheet's name. The function works fine and updates automatically until I open a new workbook; at which point the original worksheet (with the UDF) reads the cells from the newly...

I have inserted a button to allow me to refresh my data (Various info from the web), however the data will only refresh when I click the button. Is there a way to make it auto refresh every 3 minutes? Below is the data from visual basic: Sub Refresh() ' ' Refresh Macro ' '...

Hi, I am looking to build a report from multiple pivot tables and I wish to build a summary table, with data pulled off from these tables. The catch is that the pivot tables are linked to an external data source, which changes regularly. I am actually looking to get values at a particular...

Hi all, I have a looot of work books which get data from different tables in a same oracle database. I am trying not to include the VBA code in the same work sheet as people can see the passwords for the database when they open the object explorer( i know we can lock the project windows) and...