refresh button ?

I need help urgently....i'm on a deadline of COB today...if anyone could tell me how to link cells from one workbook to another and being able to update figures using the refresh (!) button???

Thanks So Much
Natalie

Hi, does anyone know a way to create a non-macro refresh button on a page. I have a table (I think it's a pivot), that takes data from anther table, but you have to right-click it and press Refresh Data, but I want to make a button on the sheet to do that.

Hi

Can anyone help me with some code, so I can add a button that replicates the ! (Exclamation mark) functionality in a pivot table.

I have some users who cannot cope with the right click option. I could add the refresh button onto their toolbars, but our IT seem to delete our customised toolbars each week.

Thanks
J

I've created a sourc e data worksheet, that kicks out to a pivot table in
same workbook. I want to add button to the sheet where the user would just
have to select it, to refresh data. Just trying to make it easy for those
that may not have their pivot table bar up, or forget to click in chart to
bring up refresh button.

Any ideas

If I want to add a refresh button to a worksheet to update a web data query how would I do this?

I have some thoughts about making a command,button or whatever that can ease my pricelist adjustment job.
I have a price list of about 1000 rows. At the end of each row I have a cell with the actual price for the actual periode. The thing is that I update some of these prices once or twice a month. But now i want to add a new column where I type in the new price as I get it. Then when I have all the prices I need I was thinking about using a command button that will insert the new prices, that I have typed in, into the cells for the old prices. Like an update/refresh button actually.
Is this in anyway possible? Do you excel pro's understand what I want to do?

All answers appreciated

Hi

Is it possible to add a page some form of Refresh button to a cell, so when
clicked all the formulas/filters on that page will refresh.
I’m sure I have seen a spreadsheet containing a Macro in the past which lets
you do this (maybe wrong)..

Thanks in advance…
Monk

Hi All,

I need a macro, where the user when opens the file the popup button should appear and ask for Refresh - ok or cancel. If cancel then it should not refresh and if they click refresh then it should RefreshAll.

Please help....

Mahi

Hi,

I am thinking about making a little tool that will allow you to run a sql query against a database via odbc, then save the query with the workbook, so when you reopen that workbook you can refresh with the latest data from the database with a click of a button.

On one hand :

I think this can already be done reasonably easily in Excel

On the other :

Many people have told me it would be really useful.

What do you think ?

Thanks
Sam H

Hi,
Can you anyone point me in the right direction? (I am not an expert btw!). I have an excel spreadsheet that extracts information from an SQL database. I want to create a button that can refresh the data on click (I don't want to use the standard one)

Any ideas?

Thanks,
Gary

Hi All,

I am the new comer in here .
I have a question about Command button in excel.
I want to create Refresh Button with command from developer. Can you help me with this ?

The refresh button is the same as refresh from pivot table function.

Thank You
Regards
Henry

I have a workbook with 7 sheets:
Result Page, DW-1, PROD-1, DW-2, PROD-2, IP-2, IP-1

The Results page from top down;
A1-4 contain Start Date, End Date, Year, and Month (this date information is used in the SQL queries to pull the correct data.)
To their right is a Recalc button linked to Macro1
Under that, starting in A7 are the summation fields
Under that, starting at A30 are PivotTables.

DW-1, PROD-1, DW-2, PROD-2, IP-2, IP-1 Sheets contain the Raw data retrieved from SQL queries.

The problem i am having is that my Macro1 is not refreshing the data and pivot tables in the correct order... and thus my results are not appearing correctly and i have to run the marco twice. I have noticed in some other posts that the code:
ActiveSheet.PivotTables("PivotTable-DW").RefreshTable
Has worked but in my instance they are returning and error:
Run-Time error '1004': Unable to get the PivotTables property of the Worksheet class

I have looked for this error online but have found nothing as far as a solution... does anyone have any suggestions, please?

~~~~~~~~~~~
Macro1:

Sub Macro1()
'
' Macro1 Macro
'
    Response = Application.InputBox("Please enter in the Start Date as: MM/DD/YYYY", "Start Date",
Range("A1").Value, 50, 150, "", , 1)
    If Response <> False Then
       ActiveSheet.Range("A1").Value = Response
    Else
        MsgBox ("Exiting Input! No Calculation will take place")
        Exit Sub
    End If
    
    Response = Application.InputBox("Please enter in the End Date as: MM/DD/YYYY", "End Date",
Range("A2").Value, 50, 150, "", , 1)
    If Response <> False Then
       ActiveSheet.Range("A2").Value = Response
    Else
        MsgBox ("Exiting Input! No Calculation will take place")
        Exit Sub
    End If
'
    ActiveWorkbook.RefreshAll
    Calculate
'
    Worksheets("Result Page").Select
    ActiveSheet.PivotTables("PivotTable-DW").RefreshTable
    ActiveSheet.PivotTables("PivotTable-MERCER").RefreshTable
    ActiveSheet.PivotTables("PivotTable-AUTF").RefreshTable
    ActiveSheet.PivotTables("PivotTable-HOMF").RefreshTable
    ActiveSheet.PivotTables("PivotTable-FPIC").RefreshTable
    ActiveSheet.PivotTables("PivotTable-iPartners").RefreshTable
    
    ActiveSheet.PivotTables("PivotTable-DW-Written").RefreshTable
    ActiveSheet.PivotTables("PivotTable-DW-Surcharge").RefreshTable
    ActiveSheet.PivotTables("PivotTable-Mercer-Written").RefreshTable
    ActiveSheet.PivotTables("PivotTable-Mercer-Surcharge").RefreshTable
'    ActiveSheet.PivotTables("PivotTable-AUTF-Written").RefreshTable
'    ActiveSheet.PivotTables("PivotTable-HOMF-Written").RefreshTable
    ActiveSheet.PivotTables("PivotTable-FPIC-Written").RefreshTable
    ActiveSheet.PivotTables("PivotTable-iPartners-Written").RefreshTable
    ActiveSheet.PivotTables("PivotTable-iPartners-Surcharge").RefreshTable
    
    ActiveSheet.Refresh
    Calculate
    Debug.Print "Macro1 ended"

End Sub

Hi,

Lucky for me, I have been tasked with 'fixing' a button within a rather large and complex spreadsheet. The button merely refreshes a macro, which pulls data from a specific column in a separate worksheet - I'll call this Column A. The refresh works fine as long as a cell in Column A is selected when I click the button. However, if a cell outside of Column A is selected, and I try to refresh, I receive a VBA run-time error 1004 with the narrative 'Application-defined or object-defined error' (which I presume is indicating a cell within Column A needs to be selected) with the options to End or Debug. As a lot of people use this workbook, keeping a cell in Column A permenantly selected proves a little tricky.

My question is: can I alter the existing macro/create a new macro so that it doesn't matter whether a cell in Column A is selected?

All suggestions welcome.

Hey there,

I have an excel 2007 worksheet working as a database.

The formulas don't change their result immediatly after you change a cell that the formula depends on, until you press the "Save" button from excel.

I'd like to know how to make excel formulas update or refresh immeadiatly,
without having to create a macro,..

if not I'd like know to code a macro for me to add a button floating on my sheet to refresh or save my entire worksheet.

Thanks in advance

Hi

I have a workbook that pulls daily data into seperate sheets for each day i.e 1st = sheet 1 and so on for the entire month.
Each sheet has the relevent date the query looks at for the information to be populated with a refresh button next to it, each day I refresh the previous days relevent sheet. Is there a way to write code so that it would refresh the correct sheet each morning at a specific time say 08:00 am automatically on opening the workbook ?

hi,

I am trying to fill a Listbox dynamically. I have a range labeled 'Dates'. This range is created dynamically when i click a refresh button. New dates are grabbed from a database, then inserted into a worksheet, then the range 'Dates' is created to define the list of dates from the database. Also, I have a Clear Button. This button deletes all the dates in the worksheet, which I would want to clear all of the selections in the Listbox.

My Questions are:

1) How do i dynamically update a listbox with a Dynamic Named Range? I currently have vba to assign the ListFillBox property with the range name. However, when i click refresh to grab a new list of dates, the ListBox object freezes and/or does not refresh with the new dates.

2) How do i clear the listbox. Currently, I have vba to assign ListFillBox = "", however this will freeze the listbox and/or not clear its content.

I am using a multiselect listbox object.

Please feel free to include any other vba (whether its related to this problem or not) regarding ListBox objects, as I am rather novice on manipulating this type of component in excel vba.

Many Thanks,
Greg

Hi,

Is it possible to put the standard Excel buttons (as in the ribbon in 2007 or the toolbars in 2003) actually on the spreadsheet. I would like, for example, to put the "pivot table refresh button" on my spreadsheet somewhere in the middle, separate from the program. Can I extract or import these Excel program's buttons somehow to insert elsewhere?

Thanks

OK - let me apologise if I have put this in the wrong place or if it has been answered via another thread - I did try to find it - but could not.

I am very new to VBA - so forgive me for asking an obvious question. (if it is)

I have spreadsheet with some very basic formulas that work out sale prices based on people entering buy prices. (It works out the % margin).

There are certain areas where the user enters the data - and does not touch any other part of the sheet.

What I am trying to do is add a button which will remove the data from these cells. Almost - a start again button or refresh button. This way it will remove previously entered data - without removing formulas from the cells where the calculation happens. I think that is clear

So basically there are cells that a user will enter data - and it is these cells I would like to be able to clear with a button or similar without affecting other cells.

i have an excel spreadsheet with 27 or so workeets.
it contains sales figures in it.

I want to be able to link mutiple cells of this workbook to another workbook so that it retreives that data, So that when I hit the refresh (!) button it will automatically put the data in.

I will recieve new sales figures (new files) on a monthly basis so i want it to be able to update the figures to the new figures.


hope this makes sense- hope you can help me.............

Appreciate It!!!!

Natalie