SUMIFS - #VALUE error with linked workbooks on Onedrive

Copper Contributor

Hi all


I am hosting some Excel documents on Onedrive. One workbook includes a number of SUMIFS formulas referenced to the second workbook.


I am getting a #VALUE error on all of these formulas, which I understand is a common issue when the formula references a closed workbook and it normally clears as soon as the linked workbook is opened.


Unfortunately I can't seem to clear the error when using Onedrive. Does anybody know of a workaround? I'm reluctant to use array formulas due to the size of files and number of links within them.


Many thanks


1 Reply


I generally use PQ to get data from OneDrive or Sharepoint instead of formulas.