Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
REF# Error even with existing data
I have a formula that reads like this
='AVALANCHE SCHEDULE'!C1 Avalanche Schedule being the name of another sheet in my workbook. It is a schedule that is very long. As a date passes, I go into the schedule and delete the top row (row 1). Everything then shifts up. The next date is now in Row 1, however the data does not populate. I get a REF# error and I don't understand why, because there is data in Avalanche Schedule C1 Please help. I have also tried ='Avalanche Schedule'!$C$1 THanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
REF# Error even with existing data
try
=indirect("'AVALANCHE SCHEDULE'!C1") this will keep it on c1 "leeblair" wrote: I have a formula that reads like this ='AVALANCHE SCHEDULE'!C1 Avalanche Schedule being the name of another sheet in my workbook. It is a schedule that is very long. As a date passes, I go into the schedule and delete the top row (row 1). Everything then shifts up. The next date is now in Row 1, however the data does not populate. I get a REF# error and I don't understand why, because there is data in Avalanche Schedule C1 Please help. I have also tried ='Avalanche Schedule'!$C$1 THanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
REF# Error even with existing data
Try this:
=INDIRECT("'avalanche schedule'!C1") Biff "leeblair" wrote in message ... I have a formula that reads like this ='AVALANCHE SCHEDULE'!C1 Avalanche Schedule being the name of another sheet in my workbook. It is a schedule that is very long. As a date passes, I go into the schedule and delete the top row (row 1). Everything then shifts up. The next date is now in Row 1, however the data does not populate. I get a REF# error and I don't understand why, because there is data in Avalanche Schedule C1 Please help. I have also tried ='Avalanche Schedule'!$C$1 THanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
REF# Error even with existing data
Just a word of warning. Indirect is a volatile function that means that it
recalulate every time the spreadsheet calculates (not just when Cell C1 changes). If you spread sheet is Very Long as you say then you should expect to take a performance hit for using this formula (may or may not be an issue)... -- HTH... Jim Thomlinson "bj" wrote: try =indirect("'AVALANCHE SCHEDULE'!C1") this will keep it on c1 "leeblair" wrote: I have a formula that reads like this ='AVALANCHE SCHEDULE'!C1 Avalanche Schedule being the name of another sheet in my workbook. It is a schedule that is very long. As a date passes, I go into the schedule and delete the top row (row 1). Everything then shifts up. The next date is now in Row 1, however the data does not populate. I get a REF# error and I don't understand why, because there is data in Avalanche Schedule C1 Please help. I have also tried ='Avalanche Schedule'!$C$1 THanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
REF# Error even with existing data
If you spread sheet is Very Long as you say then you should expect
to take a performance hit for using this formula I find it hard to believe that using this one tiny formula with Indirect will cause a performance hit! Biff "Jim Thomlinson" wrote in message ... Just a word of warning. Indirect is a volatile function that means that it recalulate every time the spreadsheet calculates (not just when Cell C1 changes). If you spread sheet is Very Long as you say then you should expect to take a performance hit for using this formula (may or may not be an issue)... -- HTH... Jim Thomlinson "bj" wrote: try =indirect("'AVALANCHE SCHEDULE'!C1") this will keep it on c1 "leeblair" wrote: I have a formula that reads like this ='AVALANCHE SCHEDULE'!C1 Avalanche Schedule being the name of another sheet in my workbook. It is a schedule that is very long. As a date passes, I go into the schedule and delete the top row (row 1). Everything then shifts up. The next date is now in Row 1, however the data does not populate. I get a REF# error and I don't understand why, because there is data in Avalanche Schedule C1 Please help. I have also tried ='Avalanche Schedule'!$C$1 THanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
macro | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Inserting additional data into an existing cell? | Excel Discussion (Misc queries) | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel |