ExcelBanter - why does a formula only work when the linked spreadsheet is open

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - why does a formula only work when the linked spreadsheet is open (https://www.excelbanter.com/excel-discussion-misc-queries/62430-why-does-formula-only-work-when-linked-spreadsheet-open.html)

sro1

why does a formula only work when the linked spreadsheet is open

why does a formula only work when the linked spreadsheet is open

Dave Peterson

why does a formula only work when the linked spreadsheet is open

There are some functions that only work with open workbooks...

=indirect(), =sumif(), =countif()

are a few (IIRC).

sro1 wrote:

why does a formula only work when the linked spreadsheet is open

--

Dave Peterson

All times are GMT +1. The time now is 02:43 AM.