Forum Discussion
Use data from one Workbook for calculations in another Workbook.
Hello, I created a new Workbook by cutting and copying a worksheet from the main Workbook, so the two workbooks have some cross communications in formulas. I saved the new Workbook on the Desktop hoping it will be like a homepage for the whole lot of worksheets I have in the main Workbook. I discovered that the formulas in the Desktop Workbook work properly only when the main Workbook is opened. Sometimes the formulas work, sometimes the whole lot of formulas in the Desktop Workbook show "Value!" until I open the main Workbook, after that the datas in the Desktop are restored. Have I done something wrong? Is there any option to fix the problem?
Frank,
some functions - like INDIRECT() or COUNTIF() - only work when the source workbook is open.
Detlef_Lewin wrote:Frank,
some functions - like INDIRECT() or COUNTIF() - only work when the source workbook is open.
Thank you, infortunately I used both :-)
I shall fix the problem from anothe side.
As a comment. In general INDIRECT works with absolute path, COUNTIF could be changed on SUMPRODUCT which also works with absolute path (COUNTIF not), etc.
Another story is what in real life you have to use this absolute path as parameter defining it manually or based on some rules, e.g. parent folder for current subfolder.
