Forum Discussion
Office 365, One drive, Excel, Replication of sheet from one excel file to another
Hi, my question is: Is it possible to create multiple excel files in Onedrive using Office 365 but with one special criteria 🙂 . I will explain in details what I want to achieve 🙂 For example ...
You can absolutely do this with references in the files, probably just in the general file really. You can reference each of the other files with a formula as long as you create the reference while the file is open from SPO.
Depending on how you are representing the information, rather than using Excel, you could also use MS lists or similar tools to store this data easier.
Depending on how you are representing the information, rather than using Excel, you could also use MS lists or similar tools to store this data easier.
SeanMcAvinue
Hello, could you tell me more details with examples?
Office 365 is in the cloud and the storage there is One drive.
Really it is possible?
I just want to put data in 5 different excel files in their first sheet and I want to see all these sheets from 5 files in on a new excel file with all 5 sheets from previous files.