Formulas Failing in Spreadsheet with a lot of conditional formatting and VBA MACROs

  • I have a spreadsheet that helps to make a daily schedule for ~30 people with ~50 assignments. I've been refining it and saving the workbook from the prior day for the subsequent day's schedule and updating the personnel for the day. Three or four people work on the schedule every day, so it is shared on a Teams drive.

    Some of the cells that use long formulas like Textjoin are now giving the error #VALUE. This is new. No part of the sheet related to those cells has changed in the past 6 months and it used to give the appropriate value in Teams. Now it sometimes doesn't give the appropriate value in desktop Excel, version listed below.

    EDIT running: Microsoft® Excel® for Microsoft 365 MSO (Version 2110 Build 16.0.14527.20336) 32-bit

    So, what should I do? Is there a shortcut to start a fresh build? Does 'autosaving' a large number of versions contribute to the problem??(

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!