MadCallidus
New Member
- Joined
- Jan 11, 2017
- Messages
- 8
Hi All,
I have a workbook with several array formulas down a column.
They each pull data from tables in a separate sheet sequentially, whereby each array formula pulls out the next available numerical cell value with multiple criteria.
On one of the sheets the 7th array formula down always refuses to stay 'entered' every time the workbook is opened (using ctrl/shift/rtn). It will accept being entered at each visit, just not stay that way.
All other array formulas above and below work fine. Any ideas as to why this might be happening?
I have a workbook with several array formulas down a column.
They each pull data from tables in a separate sheet sequentially, whereby each array formula pulls out the next available numerical cell value with multiple criteria.
On one of the sheets the 7th array formula down always refuses to stay 'entered' every time the workbook is opened (using ctrl/shift/rtn). It will accept being entered at each visit, just not stay that way.
All other array formulas above and below work fine. Any ideas as to why this might be happening?
