Refreshing/Syncing Data from Excel Spreadsheet
I have a Vertical CRM with Zoho vAnalytics. I am trying to create reports/dashboards using an Excel spreadsheet as a data source that is updated daily by production employees. I can import the spreadsheet just fine and create a report, but I don't seem to be able to pull in the new data every day automatically so the dashboard is current.
How can I accomplish this? If I have to go into analytics and manually import the new data everyday or add data to a table everyday, it sort of defeats the purpose.
Kevin