if formula issue

[AlienBeans]

I'm using the following formula in a football pool:

=IF(PlayersList!$O$13=0,"",PlayersList!$O$13)

and its supposed to reference the players name that is listed in cell O13 on the sheet named PlayersList. Now, after completing the season I am trying to expand it to accommodate 150 players instead of 100. The names go in columns so the next player would be in cell O14,O15....O27, then continue in column Q3 through Q27. My issue is that now that I'm trying to expand this sheet using the formula above, its not working correctly. I filled in the cells on the PLAYERSLIST sheet, and when i entered the formulas the "test name" came up, but its not a complete reference yet, cause when i delete the test name from the PLAYERSLIST sheet it should remove the test names on EVERY sheet, but its not working. It seems to be happening with all the formulas in the workbook, and i've never experienced this before. Is there something I've hit that has messed up my reference. It seemed to work upon input, but not when i test it. If i go to the formula bar and click in the bar then hit enter, my results that i'm supposed to be getting show up, but they don't show up automatically. Any ideas, or does this even make sense?

[davemcochrane]

I'm using the following formula in a football pool:

=IF(PlayersList!$O$13=0,"",PlayersList!$O$13)

and its supposed to reference the players name that is listed in cell O13 on the sheet named PlayersList. Now, after completing the season I am trying to expand it to accommodate 150 players instead of 100. The names go in columns so the next player would be in cell O14,O15....O27, then continue in column Q3 through Q27. My issue is that now that I'm trying to expand this sheet using the formula above, its not working correctly. I filled in the cells on the PLAYERSLIST sheet, and when i entered the formulas the "test name" came up, but its not a complete reference yet, cause when i delete the test name from the PLAYERSLIST sheet it should remove the test names on EVERY sheet, but its not working. It seems to be happening with all the formulas in the workbook, and i've never experienced this before. Is there something I've hit that has messed up my reference. It seemed to work upon input, but not when i test it. If i go to the formula bar and click in the bar then hit enter, my results that i'm supposed to be getting show up, but they don't show up automatically. Any ideas, or does this even make sense?

If you are trying to drag down the formula and the references are not changing, the $ sings are stopping you, they are absolute, so anywhere you place the formula, it will always refer to =IF(PlayersList!$O$13=0,"",PlayersList!$O$13)
Removing the $ signs then dragging the formula down will change the the references.
Not knowing what the spreadsheet looks like,the absoulte ($) may be required again, for sorting purposes, or whatnot

[AlienBeans]

well, not being an excel guru, i know of no way to have it change for me and match the cell i put it in, so I am changing the cell # on each entry i use that formula. I know the $ is absolute, and I need it that way, cause my cells that i use that formula in are not consecutive cells. Removing the $ would cause me to have to change all the entries anyway, so I just use it, and change the cell to O13, O14, O15..etc... It's only started doing this since I've been editing the workbook and expanding the players. It worked fine during the regular season when i had to add the occasional player, so I know the formula works...

[AlienBeans]

Nevermind folks. I discovered the problem. It turns out that the calculation feature was set to manual. As soon as I set it to automatic, everything fell into place and works perfectly.