Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Problems with Excel Formulas
Name: janet Date: January 9, 2006 at 18:44:52 Pacific OS: WINDOWS XP CPU/Ram: AMD1800/512 RAM
Comment:
For no apparent reason I have encountered problems with excel formulas. Instead of dragging formulas across columns, my speadsheets are copying information only. Also, summed columns of figures are not updating when changed, neither are linked cells. Can anyone suggest a solution, please. The problem is happening on old and new spreadsheets, which leads me to think there may be a problem with my program
Name: Grok Lobster Date: January 10, 2006 at 08:42:07 Pacific
Reply:
Try logging in as a different user, it may be a corrupt profile.
0
Response Number 2
Name: janet Date: January 11, 2006 at 14:07:53 Pacific
Reply:
Thanks for the suggestion. Found out that part of the problem was with the tools options. The calculation tab had reset itself to manual operation. Cheers, Janet
Summary: As most of you know excel is great in that when you want to copy & paste formulas it moves the cell references. On one of my sheets I copied and pasted a formula and all the cell references changed ho...
Summary: So I can't have markers only for my especial points, pity, this is a problem with EXCEL! Anyway thank you for your replies & hopefully we will meet each other again. Cheers ...
Summary: I am hoping someone can help me create an excel formula. Column C is the result of column A time Column B. If the resulting value in Column C is less than 8, then the value needs to be 8. If it is ...
0 
