Results 1 to 3 of 3
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Formulas not Updating (XP/SP2)

    Three people in the building all running the spreadsheets I created from my macros.
    The macro set up a hyperlink and a link to the next level. (Code below)

    Person 1 (me): Windows 2000 - Excel XP/SP2 -- files update properly opening and closing
    Person 2 (mgr): Windows XP - Excel XP -- files update properly
    Person 3 (customer): Windows 2000 - Excel 2000 -- goes to lowest level and makes a change.
    . Saves and next level up does not update. Have to go to each cell and click in formula to force a change.

    Is there some setting in Calculation that I am missing?

    Deleted temp files (just in case).

    <pre>FileSTR = FindFolder(ThisWorkbook.Worksheets("Dashboard").Ra nge("TopLevelServer") _
    & "ProductLine", myFile)
    Cells(5, szCol).Select
    ActiveSheet.Hyperlinks.Add _
    Anchor:=Selection, _
    Address:=FileSTR & myFile, _
    ScreenTip:="Budget amounts for Special Ledger are computed in PCA files" _
    & vbCr & "Jump there now" 'Hyperlink
    LngMonth = DerMonth(daMonTh)
    Cells(5, szCol).Formula = "='" & FileSTR & myFile & "'!" & LngMonth _
    & "BudTotal" 'Amount
    With Selection.Font
    .FontStyle = "Regular"
    .Underline = xlUnderlineStyleNone
    .ColorIndex = xlAutomatic
    .Size = 12
    End With
    Selection.Locked = True 'Maintain integrity of link
    daMonTh = daMonTh + 1</pre>



    Thanks
    Alan

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formulas not Updating (XP/SP2)

    Try adding this line to the code before you finish. This should trigger a complete recalc.

    <pre>Application.CalculateFull</pre>


    Steve

  3. #3
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Formulas not Updating (XP/SP2)

    Let's try another approach.

    This piece works but the user finds that they have to close the spreadsheet to get a recalc.
    I have tried <pre>Application.Volatile</pre>

    but it is only partially effective.

    I just sent someone from our area to the customer's desk. When they log on as themselves,
    it works perfectly. Seems to be something with network permissions.
    Alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •