Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
very strange linking problem in Excel
Afternoon
Something very odd is happening. I have a file containing population data by region (columns), split into 4 year age range increments (rows). In another file I am generating two rows, one for children and another for adults, with region across the columns as in the main file. The link text therefore reads something like this: =SUM([2004_LondonBoroughs.xls]Females!$L$64:$L$67) Once I've done one column, I remove the $ tags and then drag across to autofill the other columns. The figures, however, across the regions, are the same as the first column, even though the figures in the London boroughs sheet are very different. They only update correctly if I click on the cell, highlight the =SUM([2004_LondonBoroughs.xls]Females!L64:L67 text in the textbar, then hit return. I've got a lot to do so I can't do that for every single cell. What the hell's going on? It was working perfectly yesterday - same files, same technique. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
very strange linking problem in Excel
Tools/ Options/ Calculation
Make sure it's set to Automatic. It picks the setting up from the first workbook you open in a session. -- David Biddulph "Josie" <zeiderzeeAThotmailDOTcoDOTuk(DONOTSPAM) wrote in message ... Afternoon Something very odd is happening. I have a file containing population data by region (columns), split into 4 year age range increments (rows). In another file I am generating two rows, one for children and another for adults, with region across the columns as in the main file. The link text therefore reads something like this: =SUM([2004_LondonBoroughs.xls]Females!$L$64:$L$67) Once I've done one column, I remove the $ tags and then drag across to autofill the other columns. The figures, however, across the regions, are the same as the first column, even though the figures in the London boroughs sheet are very different. They only update correctly if I click on the cell, highlight the =SUM([2004_LondonBoroughs.xls]Females!L64:L67 text in the textbar, then hit return. I've got a lot to do so I can't do that for every single cell. What the hell's going on? It was working perfectly yesterday - same files, same technique. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
very strange linking problem in Excel
Just worked that out as you posted. Many thanks anyway.
:) "David Biddulph" wrote: Tools/ Options/ Calculation Make sure it's set to Automatic. It picks the setting up from the first workbook you open in a session. -- David Biddulph "Josie" <zeiderzeeAThotmailDOTcoDOTuk(DONOTSPAM) wrote in message ... Afternoon Something very odd is happening. I have a file containing population data by region (columns), split into 4 year age range increments (rows). In another file I am generating two rows, one for children and another for adults, with region across the columns as in the main file. The link text therefore reads something like this: =SUM([2004_LondonBoroughs.xls]Females!$L$64:$L$67) Once I've done one column, I remove the $ tags and then drag across to autofill the other columns. The figures, however, across the regions, are the same as the first column, even though the figures in the London boroughs sheet are very different. They only update correctly if I click on the cell, highlight the =SUM([2004_LondonBoroughs.xls]Females!L64:L67 text in the textbar, then hit return. I've got a lot to do so I can't do that for every single cell. What the hell's going on? It was working perfectly yesterday - same files, same technique. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange problem....excel not responding | Excel Discussion (Misc queries) | |||
Strange Excel Problem..... | Excel Discussion (Misc queries) | |||
Strange Excel problem | Setting up and Configuration of Excel | |||
Strange Excel Problem | Setting up and Configuration of Excel | |||
Strange Excel problem | Setting up and Configuration of Excel |