refresh issues

  1. 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...
  2. E

    Update or refresh plot while VBA running

    I have a program which iterates on command. A plot on the spreadsheet is designed to show the progress of the iteration. However, the plot does not update while VBA is running. What is the command or technique to refresh the plot at an intermediate stage in the calculation? Regards, ernieL
  3. J

    VBA fails to update a linked table - works on step through / with timer / with manual refreshall

    Hi I have a table in Access linked to 3 separate Excel sheets. They contain user forms which update the records in the table with information input into the form. Within the userform code, I'd like to do 2 things: 1. Update the records in the datatable with the user form info 2. Refresh the...
  4. A

    Pivot Table Label Not Updating - NOT a refresh problem

    Hello, I'm having trouble updating the labels on my pivot table. These labels were added AFTER the original pivot table was created. I have since refreshed the data; tried dragging the field out of the "row label" and put it back in, but to no avail. The data shows up perfectly fine; I can sort...
  5. M

    Chart Not Refreshing

    Hi: I have a stock data charted in bubble format. When a set the chart up it works fine. If I change the stock symbol in chart and reload the historical data the every chart in my worksheet refreshes except this one bubble chart. I have gone in and made sure that all links to the data are...
  6. C

    Conditional Formatting not updating when using option buttons

    Hi, I have two option buttons labelled as follows: "$ - Dollar Price" & "£ - Sterling Price", these link to Cell A1. Allowing the user to pick how they want to see the prices displayed. I have a table of prices that links runs a vlookup with an IF statement based on the value in A1...
  7. S

    VBA - Refresh Pivottable & Query

    Thanks in advance to those that can help me out! I've used this code prior and it worked fine in Excel 2007, now I'm having issues with it. Originally every Pivottable & Query pointed to a different CSV file. Now I have two pivottables built off a Excel worksheet that is built from a Query...

Some videos you may like

This Week's Hot Topics

Top