how do I sync EXCEL with CALC ?
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.
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
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
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.