Excel referenced file with google sheet

[Ben3B]

Hello I test the excel ref file in vwx 24sp2

 

I don't have an excel licence, but a google workspace with gsheet.

 

So I downloads the gsheet file as xlsx and import it as worksheet  and refenced it .

It works in one way , I can update my worksheet from the excle file (push data from xlsx tu vwx worksheet) But I can't push data from VWX to excel file .

I 've an error message who say that the file is in use bu another program (cf atch)
 

Is it a limitation from google ? does it will works with open office ? Or have I to use excle from microsoft

[Ben3B]

So it seems to be a gg drive problem, if the excel file isn't in ggdrive I can edit it both way ...

[Ben3B]

So I did test with open office calc and gsheet, I have the same problem, as soon as the file is saved in a google drive folder, I can't push the data to the file.

 

But everything works outside of gdrive folder ...

[Hugues]

@Ben3B We are not seeing the same issues with google drive folders. The error you are seeing is an indication that Vectorworks is not able to get write access to the file because another application has an exclusive lock on it. Not sure what Google Drive is doing to the file.
How big is the Excel file you are using?

Are you using the latest version of Google Drive for Desktop?

[Ben3B]

Hello I tried with an excel  file and excel soft and there is no problem , 
it looks like gsheet keep the excel file opened in background ...

But anyway I switched from google worksheet to Microsoft 365 , and everything works fine now 

The file was an empty one to test ... with just one word Inside;)