Autofill not working

E

ehundey

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

I suddenly can't use the autofill arrow to copy a formula to other boxes. I have done this thousands of times before and so I know how to do it. The formula says the right thing in each cell in the columns I am working in but I have to press enter after autofilling for every single cell to come up with the right answer, otherwise it just says the same thing as the top cell (that I initially copied from). It's not the formula because even the simplest adding formulas are not working. I have reinstalled office to no avail. Has anyone experienced this and knows how to fix it?
Thanks
Beth
 
E

ehundey

AH! I fixed it... Preferences and clicked calculation and "Automatic"...
thanks anyway!
 

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

Similar Threads


Top