Forum Discussion
Merge multiple excel files into one (the formatting of the file also)
Dear all, Im using excel 2016. me and my colleuages are working on an identical file(we make copy of the file for each one of us every morning) but we are putting data in different row and colums...
Hi! Sounds stressful work. Ever thought of a free Microsoft account? You and your pals can store ONE single excel file, stored on a OneDrive. Excel can do consolidations. But now you have no control, who changed, deleted or created something. 1000 copies don’t make sense after a while. In OneDrive and excel online you see every versioning and even can reset to a previous version. Your excel 2016 works better with a having a Microsoft account. To get that just go to live.com to create it, privatly for free. Ask your admin in your company how to get how much licences. Then go to your excel FILE tab and link it to your account. OneDrive will ease your daily work I guess. Greets, Eva
Eva Vogel The OP is talking about "colleagues" working on the files, so advising them to create personal Microsoft accounts is probably not a good idea. It will be the nightmare of any IT department to see employees farm out company files on personal cloud shares that IT can't control. I'd be very hesitant to give out such advice.