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...
    • PEDRO ABRANTES
    • Thread
    • adodb.connection adodb.recordset querytable refresh external data refresh issues
    • Replies: 0
    • Forum: Excel Questions
  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...
    • Jimmy the Hat
    • Thread
    • connection properties database connection linked tables refresh connection refresh issues
    • Replies: 1
    • Forum: Excel Questions
  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...
    • cbzdmh
    • Thread
    • conditional formatting option buttons refresh issues
    • Replies: 1
    • Forum: Excel Questions
  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...

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
Back
Top