Formulas won't work for specific user.

gazalhd

New Member
Joined
Nov 24, 2005
Messages
2
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.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

anthonya2369

Active Member
Joined
Mar 10, 2005
Messages
321
Under Options --> Calculations, make sure the user has it set to Update Automatically and not Manual or anything.
 

gazalhd

New Member
Joined
Nov 24, 2005
Messages
2
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,826
Messages
5,574,530
Members
412,601
Latest member
TheBeaniacExpress
Top