Hello,
Workbook A picks up data from workbook B. However, each time I have both spreadsheets open, all my formulas in workbook A will spit out the error #REF !
Any idea how to stop this from happening? I've been avoiding opening both spreadsheets at the same time in the past but surely there should be another way!
Any help is much appreciated.
Nhung
Workbook A picks up data from workbook B. However, each time I have both spreadsheets open, all my formulas in workbook A will spit out the error #REF !
Any idea how to stop this from happening? I've been avoiding opening both spreadsheets at the same time in the past but surely there should be another way!
Any help is much appreciated.
Nhung