Formulas in Spread sheet quit working???

R

Richie

I have a database in a spreadsheet that keeps track of
stats for a couple of teams I am on. The formulas have
quit working now. Every single formula has quit working
since I last worked on the sheet last week.

Even simple adding of columns. I can enter the
information in the columns and then go to the cell with
the formula and open and hit enter and it refreshes the
cell and starts working.

Any Ideas???? This is very frustrating.

Thanks for any help. Richie
 
R

Rick

It sounds like your auto recalculation is off. try
pushing "F9" and see if that makes it work after you
change the data, if so go to tools - options -
calculation - click automatic. Mine sometimes switches to
manual? I hope that's all
 

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

Top