Camranjaber
New Member
- Joined
- Dec 17, 2015
- Messages
- 5
Hi, I feel like I've done quite a bit of research to not have found an answer to this - please help!
Using Office 2013
Background: I work for a company that has about 20 facilities with an employee at each that performs general data entry multiple times per week for about 300 items each time (inventory tracking) into a workbook in excel (on their hard-drive), and the current process is for the people that are using this data to remotely access the computer through our host server or receive an email with the data from those at the facilities, save a back-up to their own hard-drives, copy and paste it to the compilation file, then delete the old back-up.
Obviously this is primitive, and that's why I'm seeking alternatives - I started with the company recently and the CFO simply has not had time to deal with this.
I believe some type of cloud software, ideally OneDrive, is imperative here. The problem is the following:
Primary Question: Is there a way to pull data (say, with a v- or h-lookup, or simply a cell reference) from a workbook exclusively on OneDrive from a workbook exclusively on a desktop?
Secondary Question: Is there a way to "edit links" as there is in the desktop version of Excel (the feature located in the "Data" tab)?
Follow-up Question: If the answer is purely no to these, can anyone provide an alternative "cloud" software that might do the trick, such as Google Sheets? The solution I'm looking for could include just "yes" to one of these I had the same problem with it as well for both questions, though I may have missed something.
Thanks very much for reading!
Using Office 2013
Background: I work for a company that has about 20 facilities with an employee at each that performs general data entry multiple times per week for about 300 items each time (inventory tracking) into a workbook in excel (on their hard-drive), and the current process is for the people that are using this data to remotely access the computer through our host server or receive an email with the data from those at the facilities, save a back-up to their own hard-drives, copy and paste it to the compilation file, then delete the old back-up.
Obviously this is primitive, and that's why I'm seeking alternatives - I started with the company recently and the CFO simply has not had time to deal with this.
I believe some type of cloud software, ideally OneDrive, is imperative here. The problem is the following:
Primary Question: Is there a way to pull data (say, with a v- or h-lookup, or simply a cell reference) from a workbook exclusively on OneDrive from a workbook exclusively on a desktop?
Secondary Question: Is there a way to "edit links" as there is in the desktop version of Excel (the feature located in the "Data" tab)?
Follow-up Question: If the answer is purely no to these, can anyone provide an alternative "cloud" software that might do the trick, such as Google Sheets? The solution I'm looking for could include just "yes" to one of these I had the same problem with it as well for both questions, though I may have missed something.
Thanks very much for reading!
Last edited: