Error opening some Excel files using Applications in AVD

%3CLINGO-SUB%20id%3D%22lingo-sub-2646220%22%20slang%3D%22en-US%22%3EError%20opening%20some%20Excel%20files%20using%20Applications%20in%20AVD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2646220%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20using%20Microsoft%20Windows%2010%20multi%20session%20%2B%20Microsoft%20365%20Apps%20image%20dated%204%2F25%2F2021.%3C%2FP%3E%3CP%3EOur%20requirements%20are%20Office%2032-bit%2C%20and%20we%20are%20using%20Applications.%3C%2FP%3E%3CP%3EAround%20the%20middle%20of%20July%2C%20we%20started%20receiving%20an%20error%20opening%20some%20Excel%20files%20in%20OneDrive.%3C%2FP%3E%3CP%3EWe%20have%20close%20to%20400%20users%20using%20AVD%20with%20the%20Office%20365%20E3%20license.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EMicrosoft%20Excel%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CEM%3ESorry%20we%20couldn't%20open%20'%3CA%20href%3D%22https%3A%2F%2Fcompany-my.sharepoint.com%2Fpersonal%2Fusername%2FDocuments%2Ffilename.xlsx%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcompany-my.sharepoint.com%2Fpersonal%2Fusername%2FDocuments%2Ffilename.xlsx%3C%2FA%3E'.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EClick%20OK%20button%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EMicrosoft%20Excel%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CEM%3EMicrosoft%20Excel%20cannot%20access%20the%20file%20'C%3A%5CUsers%5CUsername%5COneDrive%20-%20Company%5Cfilename.xlsx'.%20There%20are%20several%20possible%20reasons%3A%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3EThe%20file%20name%20or%20path%20does%20not%20exist.%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3EThe%20file%20is%20being%20used%20by%20another%20program.%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3EThe%20workbook%20you%20are%20trying%20to%20save%20has%20the%20same%20name%20as%20a%20current%20open%20workbook.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20open%20the%20Excel%20file%20on%20my%20local%20computer%20with%20OneDrive%2C%20no%20error.%3C%2FP%3E%3CP%3EIf%20I%20open%20the%20Excel%20file%20Online%20in%20O365%2C%20no%20error.%3C%2FP%3E%3CP%3EIf%20I%20open%20the%20Excel%20file%20using%20the%20Default%20Desktop%2C%20no%20error.%3C%2FP%3E%3CP%3EIt%20seems%20to%20only%20occur%20when%20using%20the%20applications%20in%20AVD.%3C%2FP%3E%3CP%3EOur%20workaround%20is%20to%20make%20a%20copy%20of%20the%20Excel%20file%20that%20has%20the%20error%20and%20then%20we%20can%20open%20that%20copy.%3C%2FP%3E%3CP%3EThe%20error%20does%20not%20happen%20with%20all%20Excel%20files.%20The%20files%20with%20trouble%20do%20not%20have%20any%20features%20enabled%2C%20are%20all%20.XLSX%20format.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20open%20a%20ticket%20with%20the%20Microsoft%20Tech%2C%20and%20he%20had%20me%20rename%20this%20folder%20to%20-old%20%E2%80%9CC%3A%5CUsers%5Cdc%5CAppData%5CLocal%5CMicrosoft%5COffice%E2%80%9D%20which%20seemed%20to%20work%20until%20I%20logged%20in%20the%20next%20day%2C%20then%20had%20the%20same%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20else%20seen%20this%20error%20or%20have%20any%20ideas%20on%20how%20to%20resolve%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EDenise%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2646220%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAVD%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2652918%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20opening%20some%20Excel%20files%20using%20Applications%20in%20AVD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2652918%22%20slang%3D%22en-US%22%3EWe%20are%20facing%20the%20exact%20same%20problem%20with%20a%20customer%20who%20has%20three%20hosts.%20Have%20you%20found%20a%20solution%20to%20the%20problem%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20actually%20been%20able%20to%20reproduce%20the%20issue%20like%20this%3A%20I%20create%20an%20Excel-file%20(or%20Word-file)%20using%20a%20test%20user%20where%20the%20session%20is%20hosted%20on%20say%20AVD-0.%3CBR%20%2F%3EAs%20long%20as%20the%20session%20is%20hosted%20on%20AVD-0%20everything%20is%20fine.%20When%20I%20log%20the%20test%20user%20off%20and%20force%20a%20new%20session%20to%20be%20hosted%20on%20AVD-1%20or%20AVD-2%20(by%20using%20drain%20mode)%20the%20issue%20occurs.%3CBR%20%2F%3ESo%20it%20looks%20like%20you%20can%20only%20open%20the%20file%20if%20the%20session%20is%20hosted%20on%20the%20AVD-host%20where%20the%20file%20is%20created.%3CBR%20%2F%3EWe%20are%20also%20able%20to%20open%20the%20files%20on%20local%20computers%20with%20OneDrive.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20haven't%20openend%20a%20ticket%20yet.%20But%20%22glad%22%20to%20hear%20that%20we%20are%20not%20alone%20in%20facing%20this%20issue.%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20regards%3CBR%20%2F%3EJonas%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2659291%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20opening%20some%20Excel%20files%20using%20Applications%20in%20AVD%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2659291%22%20slang%3D%22en-US%22%3EWe%20are%20seeing%20the%20same%20problem.%20Started%20happening%20july%2020.%3C%2FLINGO-BODY%3E
Contributor

We are using Microsoft Windows 10 multi session + Microsoft 365 Apps image dated 4/25/2021.

Our requirements are Office 32-bit, and we are using Applications.

Around the middle of July, we started receiving an error opening some Excel files in OneDrive.

We have close to 400 users using AVD with the Office 365 E3 license.

 

Microsoft Excel
Sorry we couldn't open 'https://company-my.sharepoint.com/personal/username/Documents/filename.xlsx'.

Click OK button

 

Microsoft Excel
Microsoft Excel cannot access the file 'C:\Users\Username\OneDrive - Company\filename.xlsx'. There are several possible reasons:
The file name or path does not exist.
The file is being used by another program.
The workbook you are trying to save has the same name as a current open workbook.

 

If I open the Excel file on my local computer with OneDrive, no error.

If I open the Excel file Online in O365, no error.

If I open the Excel file using the Default Desktop, no error.

It seems to only occur when using the applications in AVD.

Our workaround is to make a copy of the Excel file that has the error and then we can open that copy.

The error does not happen with all Excel files. The files with trouble do not have any features enabled, are all .XLSX format.

 

 

I did open a ticket with the Microsoft Tech, and he had me rename this folder to -old “C:\Users\username\AppData\Local\Microsoft\Office” which seemed to work until I logged in the next day, then had the same error.

 

Has anyone else seen this error or have any ideas on how to resolve?

 

Thanks,

Denise

3 Replies
We are facing the exact same problem with a customer who has three hosts. Have you found a solution to the problem?

I've actually been able to reproduce the issue like this: I create an Excel-file (or Word-file) using a test user where the session is hosted on say AVD-0.
As long as the session is hosted on AVD-0 everything is fine. When I log the test user off and force a new session to be hosted on AVD-1 or AVD-2 (by using drain mode) the issue occurs.
So it looks like you can only open the file if the session is hosted on the AVD-host where the file is created.
We are also able to open the files on local computers with OneDrive.

I haven't openend a ticket yet. But "glad" to hear that we are not alone in facing this issue.

Best regards
Jonas
We are seeing the same problem. Started happening july 20.