Skip to Main Content
Status New idea
Categories Desktop & Hosted
Created by Guest
Created on Jun 29, 2018

Excel formulae format in export

When QB Premier & Hosted export an Excel spreadsheet, formulas always contain refence to a tab name - usually 'Sheet1!'.  This means that if the content of the tab is copied and pasted, it refers to the original spreadsheet.  This can be a nuisance. The problem can be fixed by a "search & replace" but it would be better if this is not needed.  Having the tab reference in the formula serves no purpose and it's a nuisance.  Stop it.

  • Attach files