[Solved] OpenOffice Calc vs Data Mode

Discuss the spreadsheet application

[Solved] OpenOffice Calc vs Data Mode

Postby Sbusy67 » Tue Nov 26, 2019 11:19 pm

Hi, I wonder if a Data Model Excel file can work in Open Office Calc by unilateral linking or much better with reciprocal linking, meaning once I update one of the files (example in Excel), the update will be reflected in the other one (OO Calc). Cheers!
Last edited by Hagar Delest on Wed Nov 27, 2019 9:11 am, edited 1 time in total.
Reason: tagged solved
OpenOffice version 4.1.7 / OS Windows 10 64-bits
Sbusy67
 
Posts: 2
Joined: Tue Nov 26, 2019 11:15 pm

Re: Open Office Calc vs Data Mode

Postby Villeroy » Tue Nov 26, 2019 11:35 pm

Store data in a database. Link Ecxel and Calc to the database.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 27895
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Open Office Calc vs Data Mode

Postby Sbusy67 » Wed Nov 27, 2019 1:24 am

Villeroy wrote:Store data in a database. Link Ecxel and Calc to the database.


Thanks Villeroy! Related thread at https://answers.microsoft.com/en-us/mso ... 4558790927
OpenOffice version 4.1.7 / OS Windows 10 64-bits
Sbusy67
 
Posts: 2
Joined: Tue Nov 26, 2019 11:15 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 25 guests