Disappearing Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet set up with a sheet for every day of the month to be
used for accounting functions; I have a blank copy that I save and fill in
for every month. For some inexplicable reason, I have a number of formulas
that randomly disappear on random days(sheets) in the spreadsheet. For
instance, there is a column with 8 rows that never change; they are in the
same place on every sheet and the formula never changes in them. But, on one
day(sheet), a couple of the formulas will be missing; then, on the next day,
they will be there again only maybe another formula will be missing on this
one. I have tried several times to correct this, but every month when I
start the new spreadsheet, the same thing happens. It seems totally random
as to which formulas disappear on which days.

Has anyone else experienced this? Does anyone know who to fix it? It isn't
too terribly time consuming to fix it myself, but it's really annoying to
have to do it all the time.
Thanks
 
I have had this happen when I have all sheet selected (and not know it) and
modify one of the sheets. Could this be happening?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top