Referencing Another Workbook/File

[tediichan]

Hi all,

I have a workbook Main.xlsx that references another workbook Source.xlsx using an IF(COUNTIF(....)) function in the Main.xlsx.

When both workbooks are open, the formulas in the Main.xlsx workbook return values and everything works fine. But as soon as I close the Source.xlsx workbook, the cells in the Main.xlsx workbook returns a #VALUE error.

Any advice on how to get the Main.xlsx workbook formulas to work without needing the Source.xlsx workbook being open?

Cheers,
E

 

[dermie_72]

This information might help:

Excel Tutorial: How To Reference Data In A Closed Workbook Excel

Introduction Are you tired of constantly having to open multiple workbooks in Excel just to reference data? In this Excel tutorial, we will explore the process of referencing data in a closed workbook, saving you valuable time and effort. Being able to reference data in a closed workbook is...

excel-dashboards.com