Forum Discussion
Automatic spill range reference
Hello,
Excel is now automatically using spill range (for example: =sum(C86#)) instead of using =SUM(C86:Q86) as before. It a problem my customers are not always on Excel 365 and then the spill range doesn't work for them. Is there an option to stop this automatic # formula?
1 Reply
To my knowledge that's only not to use spills. Even if you use =SUM(C86:Q86) user without 365 can't recalculate the sheet, spill itself won't work.
