Live Reports Misconceptions - Are Cell References Breaking?

December 7, 2021

Live Reports Misconceptions - Are Cell References Breaking?

Live Reports is one of our Google Sheets Add-ons most popular features. Import a report once and it will automatically be up-to-date with the most recent data - both for you, and your clients.

One of the most common misconceptions people have about Live Reports is that they'll break their cell references and formulas if they customise their reports or refresh their data.

Addressing The Misconception:

When you refresh your reports or add a new column to your report, your cell references will not break! Your formulas will remain in place and you will not waste time setting up your spreadsheet again after refreshing your report.

We recommend you try this for yourself. Refresh all your reports, customise them and watch your data update in real time! 

For a Beginners Guide on How to Use Live Reports 👇

Try out our Google Sheets Add-on for free. Still have questions? Get in touch at, we’d love to hear from you! 

QuickBooks Online to
Excel & Sheets simplified
Create powerful, live reports in minutes.

Our average customer saves 192 hours per year!
Book a demo

Continue reading

Set your financial reporting on autopilot. Goodbye manual work.

Eliminate manual data entry and create customized dashboards with live data.