We have had several users open either very large excel files or several decent size files and then have excel close and lose unsaved work. It doesn't seem to be server or user specific and I haven't been able to narrow down a size threshold at which this happens. Any ideas???
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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel 2000
- Thread starter dheida
- Start date
Have you taken a look at the event logs for any indications? I have experienced similar problems (although did not have anything to do with the size of the file) with applications closing. Our situation had to do with printer drivers that were not TS aware.
dheida,
Are the excel files and the citrix servers in the same location?
I've seen in the past when a user would open a large file on a remote server that it would close unexpectedly.
The citrix server would be in one location and the file server would be in a remote location.
If the file server is in a remote location I would copy the files over to the same subnet as the Citrix server.
Then I would tell your users to test out the new configuration and see how it goes.
Hope that helps.
Are the excel files and the citrix servers in the same location?
I've seen in the past when a user would open a large file on a remote server that it would close unexpectedly.
The citrix server would be in one location and the file server would be in a remote location.
If the file server is in a remote location I would copy the files over to the same subnet as the Citrix server.
Then I would tell your users to test out the new configuration and see how it goes.
Hope that helps.
- Thread starter
- #4
Well, thanks for the suggestions but it just got weirder (if that's a word). One of the users it was happening to always opened her spreadsheets through the Citrix Excel even though she had a desktop with Office loaded on it. When this first happened I told her to just use Excel on her local machine. Lo and behold it happened to her while running Excel on her local machine. Then she informed me that it only happens when she has one particular (and pretty big) file open and then opens another. Unfortunately, the other user with this issue (Citrix only user) opens completely separate spreadsheets. The only thing that is common between the two is that it happens when one SS is already open and then another one is opened. I've probably gone on too much here but it just keeps getting worse.
Just another fyi... we just experienced similar problems with users on our network that have the office apps installed locally on their computers... for us, it was in fact an issue with printer drivers (a sharp driver to be exact) when they received a new printer in their dept.
Excel 2000 has a RAM usage problem. We went through the same problem that you are experiencing. For versions prior to Excel 2002, there is a 64 MB limit on Excel's memory usage. This limit was increased to 128 MB in Excel 2002, and to a full 1 GB in Excel 2003. Details are found in the following Knowledge Base article:
These memory limits are per-instance, which means that you may have troubles if you open multiple workbooks whose aggregate memory usage approaches or exceeds the limits noted above. If you have several very large workbooks, you may want to open them in separate instances of Excel.
Tony
These memory limits are per-instance, which means that you may have troubles if you open multiple workbooks whose aggregate memory usage approaches or exceeds the limits noted above. If you have several very large workbooks, you may want to open them in separate instances of Excel.
Tony
- Thread starter
- #7
- Status
Similar threads
- Locked
- Question