Hi, I manage a fairly large spreadsheet with a challenge: it lives on a shared drive, and a number of people with varying Excel skills have access to it and are required to update it with forecasted figures which sometimes change.
Regular use of the spreadsheet often causes my summary formulas to turn into errors.
If one of the forecasted numbers changes and now needs to move to a different week, folks will sometimes just drag that cell over to the new column. This dragging causes formula errors.
(I know what you are thinking, just ask them to NOT drag cell contents: let's just say that's not an option so I must work within these constraints).
My summary totals at the bottom require me to segment the group in a number of different ways.
But if you drag either of the yellow cells (or any other cells w/data) to a different week, that is what triggers the formula error.
How do I avoid this? thank you.
PS I have a mac, couldn't get XL2BB to work....
Regular use of the spreadsheet often causes my summary formulas to turn into errors.
If one of the forecasted numbers changes and now needs to move to a different week, folks will sometimes just drag that cell over to the new column. This dragging causes formula errors.
(I know what you are thinking, just ask them to NOT drag cell contents: let's just say that's not an option so I must work within these constraints).
My summary totals at the bottom require me to segment the group in a number of different ways.
But if you drag either of the yellow cells (or any other cells w/data) to a different week, that is what triggers the formula error.
How do I avoid this? thank you.
PS I have a mac, couldn't get XL2BB to work....