Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel 2000 vlookup not working automatically

  • 17-08-2012 11:24am
    #1
    bmay529
    Registered Users, Registered Users 2 Posts: 403 ✭✭


    I am using Excel 2000 and recently had a office network server upgrade installed. This seems to have changed my user profile. Up to now I have spreadsheets that use the vlookup command to import data from other speadsheets. Up to the time of the server change it would always update the primary spreadsheet with any changes made to the other spreadsheets automatically. Now it does not do it automatically. If I go into a cell and hit return it will update that cell correctly. Tools/Options/Calculation is set to automatic. Would appreciate if anyone has any ideas how to fix it. Thanks


Comments

  • #2
    Lu Tze
    Registered Users, Registered Users 2 Posts: 3,498 ✭✭✭Lu Tze


    Does hitting F9 update all the cells?


  • #3
    bmay529
    Registered Users, Registered Users 2 Posts: 403 ✭✭bmay529


    No, F9 has no effect


  • #4
    fionny
    Registered Users, Registered Users 2 Posts: 2,367 ✭✭✭fionny


    Then it sounds like its an issue with the excel cells not refreshing rather then not calculating.

    If you save and re-open the sheet does it show the updated version?


Advertisement