Formulas won't work for specific user.

[gazalhd]

Hello, I have a user who uses excel on a daily basis for costing spreadsheets etc. At this site they are using citrix via a network so all spreadsheets are kept on a central server and accessed by via the network through citrix. Recently this user has had problems with Excel not updating fields when new data is entered in fields with formulas attached. It only happens to this user no matter what PC she logs onto. Any other user with access to that server and those spreadsheets won't have a problem when new data is entered in the fields. However, if the user copies the spreadsheet and emails it, the recipient will have the same problem as that user. Please help as our experts don't know.

 

[anthonya2369]

Under Options --> Calculations, make sure the user has it set to Update Automatically and not Manual or anything.

 

[gazalhd]

Anthony, thanks for your reply, i have gone through checked all the settings in excel and they are the same for all users, no difference. One train of thought was that the cells have been made text only or general cells, but this wouldn't account for the fact that all other users can use the spreadsheets successfully and only the one user has problems. The spreadsheets are on a server and excel is accessed through citrix so it is not user specific.