SimonKravis
New Member
- Joined
- May 31, 2010
- Messages
- 2
For a particular spreadsheet, the fill function replicates the value from the first cell in filled cells rather than recalculating them from from cell formulae. The result of setting cell B1 to =A1 and filling down to B5 is the following:
Clicking on cell B2 shows the formula =A2 as expected, and double-clicking and selecting the tick box updates B2 to the expected value of 2.
The spreadsheet was in Excel 2003 format and viewed with Excel 2007, but the same behaviour was observed when saving to.xlsx format. Other spreadsheets show the expected behaviour when filling down from B1 to B5.
It seems as though the spreadsheet showing this behaviour has become corrupted in some way - is there any way to fix it other than transferring date to a new spreadsheet?
Code:
A B
1 1 1
2 2 1
3 3 1
4 4 1
5 5 1
Clicking on cell B2 shows the formula =A2 as expected, and double-clicking and selecting the tick box updates B2 to the expected value of 2.
Code:
A B
1 1 1
2 2 2
3 3 1
4 4 1
5 5 1
It seems as though the spreadsheet showing this behaviour has become corrupted in some way - is there any way to fix it other than transferring date to a new spreadsheet?