loading from the cloud

[alrodopial]

Hi,
I'm trying to somehow link ba with an excel file stored in onedrive
I want to use the "log multiple sheets quick link" from ba to be easy to start it
Is it possible to be done?
or does the excel file needs to be opened and then manually link tabs to sheets?

[MarkRussell]

Hi,

Sorry it will not work.
The Excel file must be on your computer's local drive because of security reasons.

Regards,
Mark

[alrodopial]

I tried to connect ba to an open excel file from cloud but it wasn't updating the data
though the com was working
so mark there is no way to make ba work with cloud file?

[MarkRussell]

Hi,

It's to do with the way the software connects to Excel and Microsoft security.
It's not something you can change.
I'm not sure that we can make it work.

Regards,
Mark

[tsiri]

Hi

I had same problem with a HP envy laptop, trying to run automated excel off onedrive.
Even copies stored on its desktop or in documents are affected.

But I found it has no problem to run gruss with automated excel books stored on Dropbox.
So thats get around I used if any help.

[alrodopial]

Thanks tsiri,
I'll check it and report later

[alrodopial]

Dropbox basic plan (free) stores files locally and syncs then with your cloud folder
So I guess if you link ba to an excel file stored locally in your dropbox it will work
but this is not what I asked for
I wanted nothing to be stored locally
The dropbox plus plan (paid) stores files only in the cloud and not in your local hard drive but I don't have such plan to test it
I guess it will be like onedrive, so it will not work