| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWorkbook.RefreshAll deosn't work in shared mode, "calculate" doesn't either
have a shared workbook with some fairly intensive calculations
included, so I have the application calculate set to xlmanual as default. I have some query tables that the workbook then does some analysis on and gives out results when the user pushes a button. All this works fine and perfect when in exclusive mode. However when I share the file I get Error 1004 when ActiveWorkbook.RefreshAll is called and Selection.Calculate does not update the results from the querytable, even though no errors pop up. Can someone please tell me what is going on? I can provide code if that will help. Cheers, SK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" | Excel Discussion (Misc queries) | |||
| Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
| Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
| "Activeworkbook" function not valid when workbook embedded in Lotus Notes? | Excel Programming | |||
| ActiveWorkbook.Protect password:=range("rangename") does not work | Excel Programming | |||
Threaded Mode
