I have an Excel file, which has macros, which is to be accessed by 3 people in different locations. I've discovered that the macro files must also be on each individual's machine for them to work (yes, I'm rather niaive on this stuff )
1. With OneDrive and (paid for) 365, will it be possible to open, and work on, the Excel file (using Macros)? If so, presumably the macro files would also need to be in OneDrive so could they just sit in a folder or would they need to be in the same folder as the file?
2. Would this also work with the 'free' 365, should it be necessary?
3. Would this set up work in Google Drive (I suspect not)?
4. Would it be neccessary to download the Excel file to work on, regardless of where it was in the cloud?
I'm unsure as to how these 'drives' work with regard to opening/working on them in the 'cloud'. Would someone be able to explain and/or recommed the best method of sharing such Excel file, please, or point me in the direction to find this information. I don't know quite how to phrase it for Google search
Please ask if you need any further information to help you understand what I'm trying to ask.
Many thanks
1. With OneDrive and (paid for) 365, will it be possible to open, and work on, the Excel file (using Macros)? If so, presumably the macro files would also need to be in OneDrive so could they just sit in a folder or would they need to be in the same folder as the file?
2. Would this also work with the 'free' 365, should it be necessary?
3. Would this set up work in Google Drive (I suspect not)?
4. Would it be neccessary to download the Excel file to work on, regardless of where it was in the cloud?
I'm unsure as to how these 'drives' work with regard to opening/working on them in the 'cloud'. Would someone be able to explain and/or recommed the best method of sharing such Excel file, please, or point me in the direction to find this information. I don't know quite how to phrase it for Google search
Please ask if you need any further information to help you understand what I'm trying to ask.
Many thanks