"What's wrong with Excel - Basics don't work" Topic
5 Posts
All members in good standing are free to post here. Opinions expressed here are solely those of the posters, and have not been cleared with nor are they endorsed by The Miniatures Page.
Please avoid recent politics on the forums.
For more information, see the TMP FAQ.
Back to the Computer Stuff Plus Board
Areas of InterestGeneral
Featured Hobby News Article
Featured Link
Featured Ruleset
Featured Workbench Article Using pink stuff for basework.
Featured Profile Article The Editor is invited to tour the factory of Simtac, a U.S. manufacturer of figures in nearly all periods, scales, and genres.
Current Poll
Featured Book Review
|
| Last Hussar | 09 Mar 2013 12:23 a.m. PST |
At work there is a spreadsheet, Column G has a date, column R has days allowed to resolve Target date column uses formula =G[n]+R[n] Doesn't work. Change the entry in R and nothing happens. You have to drag the formula on autofill from the cells above, and even then it stops after a couple of calcs. Auto update is on
When you click in the formula it highlights the cells it is getting its info from ok. No idea why it has stopped. Any ideas? |
| kreoseus2 | 09 Mar 2013 1:03 a.m. PST |
Pephaps the format of the target cells is wrong.Change the format and see what happens. Phil. |
| Waco Joe | 09 Mar 2013 8:47 a.m. PST |
Maybe it is the Mayan version |
korsun0  | 09 Mar 2013 10:33 p.m. PST |
Are the cells in R formatted correctly? Are they numbers or is it general or text? I had a similar issue once where I formatted cells as text so ensure I picked up leading 0s. Didn't work. I thought it should but it didn't until I reformatted the cells. |
 javelin98 | 11 Mar 2013 2:40 p.m. PST |
If R was formatted as text, then you'd be seeing a #VALUE! error. Last Hussar, what version of Excel are you using? |
|
