Even if it is unable to save the file I'm not sure why it would cause the file menu to be unavailable until Excel is restarted. I have seen a lot of articles on this but none that mention that the file menu freezes. We can then close Excel and then re-open the file to allow the file menu to work again. On rare occasions it will let us save the file to the users desktop on the terminal server. We usually end up having to copy and paste the whole spreadsheet into Excel outside of Citrix, save the file and then upload it which is a real pain. Usually when this issue happens the file menu is unavailable so we have to add the save as button to the quick access toolbar at the top and then after clicking "save as" and then pointing it to any network location we get the error message. xls files that we inherited from the company that we purchased the business from but the same issue happens on newly created. We are a new company so have never used an older version of office on our system. Our users all use the same version of Microsoft Office as they log onto one of the terminal servers that are configured identically. save will ensure they are applying the correct extension and that is saving to the correct directory. xlsx (ie, saving as a temp) and/or its trying tosave it in the temp directory. They need to do a "save as" instead of a save. I suspect the temp file may be becoming corrupt for whatever reason.įirst of all.do all the shared users have the same version of excel on their machines? it could be a version issue. Most of the time it will not allow to save anywhere but occasionally they can save to their local desktop. If they manually choose the location and choose the network drive it says "document not saved". I believe the issue is when it tries to save from this temp file and overwrite the original. When they take a document from the shared drive doesn't it create a temp file? You can check where it is trying to save by going to 'save as' and if it's a different location than the shared drive, navigate to the shared drive manually and attempt a save. There are no cables involved only virtualised network adaptors that talk to each other. They both sit on the same physical hardware so the connection speeds will be very fast. The terminal server that they are connected to is a virtual server and the file server is also virtualised. I thought this may be part of the issue although one user had this issue with a file that was tiny a few times. The files sizes vary with some of them being very large spreadsheets. PITA i know, but it's the nature of the beast! The only thing you can really do is to copy the file to the local system, work on it locally, then copy back to the server once finished editing I've had this headache many times before. Microsoft Excel + Large/Complicated Spreadsheet + Slow network = All of the issues you have described. What is the size of the file? Speed of connection? I think I saw a thread on this previously but I will look into this in more detail, thanks. I believe the GPO for this only applies if offline files are being used which are not used in this situation. Try to see if u have the settings active and remove it. My problem was from a settings from GPO "Files not cached" where i put *.tmpĪfter i change it to "Not configured" and my office can save on the network again I have windows 2008 server r2 and windows 7 pro station whit office 2010. Only one user at a time is trying to access the file/s and this happens with multiple files. How many users trying to use the same Excel sheet when it happens ? Is anybody able to help with this please? The version of office is Microsoft Office Professional Plus 2010 32-bit. They then open files from our file server which is another Windows Server 2008 Our users connect onto one of the Windows We run a terminal environment using Citrix with Windows Servers 2008 r2. I also found a hotfix here http:/ / / kb/ 983458/ en-gb but this doesn't apply to our server. The only fixes that I have found for this are to save files on a local drive rather than the network which is not aįix. Then on occasions it will let the user save to their local desktop. The file menu normally freezes and the only way to get to the save button again is to add it as a xlsx document from a shared drive they occasionally get an error message when they try to save saying We currently have an intermittent issue with Excel 2010.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |