With Google Sheets I could pump data into a "database" table in a “database” sheet, and then in other sheets run analytics on that data.
With excel, if I have the excel file open, then zapier cannot access it at all. This means that zapier is completely useless with excel - if all I can do is create a database that cannot be used, well, then it’s useless.
How do you work around this? I need to be able to work on other sheets in my excel workbook while zapier is pumping in data.
Thanks