Ask Your Question
0

Sync MS office with Libre Calc

asked 2019-10-20 22:10:30 +0100

Bales gravatar image

updated 2019-10-20 22:12:00 +0100

how do I sync EXCEL with CALC ?

edit retag flag offensive close merge delete

Comments

What do you mean by sync EXCEL with CALC - Excel is a program and CALC as well; thus the question seems to make no sense at all. Please describe your current situation and what you want to achieve. Please do not use Add Answer but edit your question.

Opaque gravatar imageOpaque ( 2019-10-20 22:29:35 +0100 )edit

I have been using Excel for some time. I am transitioning to Libre Calc. but for a while I have made entries in both spreadsheets. CALC is not updating with some entries recently made in EXCEL. So, I'd like to sync the data on both before I stop using EXCEL

Bales gravatar imageBales ( 2019-10-20 22:59:59 +0100 )edit

Does that mean some of your data considered "most recent data" are stored in the "Excel version" of your spreadsheets(s), while other "most recent data" are stored in the Calc version of the respective spreadsheet(s)? Or in other words: None of both can be considered being the master document?

Btw: Which format are you using for Excel spreadsheet and which one for the Cal version of a spreadsheet

Opaque gravatar imageOpaque ( 2019-10-20 23:34:47 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-10-21 10:24:44 +0100

keme gravatar image

updated 2019-10-21 10:27:44 +0100

Possible reason for content out of sync

When you work in a recent version of Excel, primary storage (suggested by Excel) will usually be the OneDrive cloud storage. You must specifically select to store "on this computer".

When you work in LibreOffice Calc, primary storage will be a folder on a hard disk in your computer (or in some cases a mapped/mounted "home folder" on your corporate network). You can't save directly to cloud from LibreOffice (only by way of a syncronized local folder).

If you don't have automatic sync enabled (see below), the two storage regions "Local" and "Cloud" are independent.

proposed solutions

  • The OneDrive client application can be set up to synchonize a "local" (computer/network) folder to the OneDrive cloud storage. Make sure you have sync set up. With that, a file stored in the local OneDrive folder and one in OneDrive cloud storage will be synchronized if they share the same ID (path/filename).
  • Be conscious of where you store your files, make sure you are really working on the same file from both applications.

Pitfall

Calc and Excel both have options for "concurrent editing", but they use different mechanisms for content locking, so using both applications for editing the same file simultaneously is likely to mess up the file. This may happen by accident when you are in the transition process you mentioned. If you are the only user, and take care to only open a file from one of the applications at a time, this is not going to be an issue.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-10-20 22:10:30 +0100

Seen: 41 times

Last updated: Oct 21