question

Evan001-5430 avatar image
0 Votes"
Evan001-5430 asked eirikv commented

Office Cache Causing Sharepoint Issue With Multiple RD Servers

Good morning,

We use multiple Remote Desktop servers along with Teams, Sharepoint, and Office products. What we have noticed is that when a user is logged into ServerA and opens an Office file (word, excel, etc) from the Sharepoint site, the cache is populated with temporary files as normal. This user profile that includes that cache will follow the user if they were to log off of ServerA and log into ServerB. Now when they attempt to open the document from the SP site, they are given an error that says "Sorry, we couldn't open 'http://sharepoint/website/path/filename.docx'." We have been clearing the Office cache for users when they encounter this issue, but is there any way to actually solve this issue without having to "work around" by wiping the cache on log off/log in?

Thank you,

office-sharepoint-server-administrationoffice-sharepoint-server-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ElsieLu-MSFT avatar image
0 Votes"
ElsieLu-MSFT answered ElsieLu-MSFT commented

Hi @Evan001-5430 , welcome to Q&A forum!

Per my research, currently clearing the cache is the only work around. And you could also open a support ticket for more help if urgent.

Similar posts for your reference:
Sorry we couldn't open document Word, Excel
Error opening office documents from SharePoint 2013
Error: Sorry, we couldn't open 'filepath/filename' received


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Evan001-5430 , is there any update?

0 Votes 0 ·

Not what I was hoping for, but I have made a log on script that clears the Office cache .C4 file which has been working.

0 Votes 0 ·

Thanks for the reply. We will continue to follow up on this thread, and if you have any updates, welcome to post here to share with other users.

Thanks for your support and understanding. :)

Good day!

0 Votes 0 ·
eirikv avatar image
0 Votes"
eirikv answered eirikv commented

Would be nice with an explanation from Microsoft here. This is new behaviour. It seems $env:LOCALAPPDATA\Microsoft\Office\16.0\OfficeFileCache do not support roaming anymore or there are issues with creating the .C4-file.

Take a look here. This is from procmon at time of the error:

124580-image.png

Excel tries to create the cache file and apparently it is a success.
The actual folder and file never gets touched, though.

124566-image.png

Notice the timestamp in both screenshots.

This should do the trick of you want to clear the cache at logon with a powershell script.

$folders = get-childitem $env:LOCALAPPDATA\Microsoft\Office\16.0\ | where Name -like OfficeFileCache*
foreach($folder in $folders){
Remove-Item -Path $folder.FullName -Recurse -Force
}



image.png (57.4 KiB)
image.png (24.3 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi

Could I use this GPO for the same effect?

"Delete files from Office Document Cache"




0 Votes 0 ·
eirikv avatar image eirikv MartinSimonsen-5798 ·

It's been awhile, but from what I remember that GPO did not work for us.

0 Votes 0 ·