We have several excel files on our network. When i open up these excel files from my Citrix session, all my formulas don't get updated when i change the data. When i highlight the cell, i still see the formula but it doesn't change when i change any of the data. This doesn't seem to be a problem on my local machine. My cell with the formulas get updated as the data changes. Any one have any ideas or solutions to this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formulas in Excel not updating in a Citrix Session 1
- Thread starter jen2lee
- Start date
-
1
- #2
Are the general settings in Excel on citrix set to automatically update or whatever they do, no excel expert here. If they are not then
1. Get everyone off the system
2. issue "change user /install" at command line
3. run up excel
4. make changes to reflect the automatic updates etc.
5. close excel
6. issue "change user /execute" at command prompt
7. test as a user.
[blue]Arguably the best cat skinner around ! [/blue]
Cheers
Scott
1. Get everyone off the system
2. issue "change user /install" at command line
3. run up excel
4. make changes to reflect the automatic updates etc.
5. close excel
6. issue "change user /execute" at command prompt
7. test as a user.
[blue]Arguably the best cat skinner around ! [/blue]
Cheers
Scott
- Thread starter
- #3
- Thread starter
- #4
A little explanation here for you and others.
No users must be on the server at the time you do this or it can cause problems.
By changeing the mode to install it forces the system to look at what you are doing, and it installs info into HKLM.
It puts changes you make into ahem HKLM/Softwar/microsoft/Window NT/Current Version/Terminal Services/install/software/<vendor>/<product> etc
You then put the machine back into execute mode.
The users log on and they run Excel.
If this is the first time they run Excel/office product, the system looks at HKCU and doesn't find anything, citrix then intervenes and says don't panic have this and copies the keys fromm the above key. If it is not the first time they have run it it will check to see if there have been any changes in HKLM and copy only them.
What can we do with this predictive behaviour.
Well it allows us to set their user drives their dictionaries and normal.dot locations before the users ever get near them.
[blue]Arguably the best cat skinner around ! [/blue]
Cheers
Scott
No users must be on the server at the time you do this or it can cause problems.
By changeing the mode to install it forces the system to look at what you are doing, and it installs info into HKLM.
It puts changes you make into ahem HKLM/Softwar/microsoft/Window NT/Current Version/Terminal Services/install/software/<vendor>/<product> etc
You then put the machine back into execute mode.
The users log on and they run Excel.
If this is the first time they run Excel/office product, the system looks at HKCU and doesn't find anything, citrix then intervenes and says don't panic have this and copies the keys fromm the above key. If it is not the first time they have run it it will check to see if there have been any changes in HKLM and copy only them.
What can we do with this predictive behaviour.
Well it allows us to set their user drives their dictionaries and normal.dot locations before the users ever get near them.
[blue]Arguably the best cat skinner around ! [/blue]
Cheers
Scott
- Status
Similar threads
- Locked
- Question
- Locked
- Question