Hello everyone,

I'm new to this forum and hope you can help me with this.

I have created a separate workbookB to organize data from another workbookA. I only use simple formulas ie: '=workbookA!$B2' thus rearranging the data from workbookA into a more concise one in workbookB. WorkbookA is actually exported excel file from an accounting software. Everytime I want to view the the data, I need to export the file (named as workbookA.xls) and then view it through workbookB. The problem now is everytime I export the file, I need to open both workbookA and workbookB to be able to view data in workbookB. Is there a way to view the data in workbookB without the need to open workbookA everytime data is updated?