Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro in Excel not updating spreadsheet
I have an embedded macro that runs when a certain spreadsheet is called from
inside access. For the most part the sheet works on certain machines but will not run on all computers. I am kind of baffled why the spreadsheet will not open up and refresh. The code I have under the spreadsheet is: Private Sub Workbook_WindowActivate(ByVal Wn As Excel.Window) Macro1 Application.WindowState = xlMaximized Wn.WindowState = xlMaximized End Sub Module1 Sub Macro1() ActiveSheet.PivotTables("PivotTable1").RefreshTabl e End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Excel Spreadsheet | Excel Discussion (Misc queries) | |||
Updating graphs in Excel using a macro | Excel Discussion (Misc queries) | |||
Automatically updating data from another excel spreadsheet | Excel Worksheet Functions | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
updating invoice number on excel spreadsheet | Excel Worksheet Functions |