I want to make an libre office data analysis template
And make the source outside file…
Like make button * Upload Sales*
And Link between Source data base
And the day sales
Where Sales belongs to categories…
which i can’t Recognise unless it link to source database
So we have
Source data base
I- Link them
II- Auto Recalculate and analysis Template to show results.
- Hope i can connect it automaticaly with no needs to copy and paste sales data
Or shall i link data but have to copy sales manual to work sheet to get analysis?
And if so, How to do it ?