| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula from one workbook/worksheet to another
I have entered formula
=('L:\Quality Improvement Projects\2008\[2008 Advanced Directive Monitor.xls]Summary by Provider'!c10) It does not bring the information from worksheet Summary by Provider to the new worksheet. It just displays the formula in the cell. What am I doing wrong. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula from one workbook/worksheet to another
The cell is probably formatted as text.
Format as General and re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "SuziQ" wrote in message ... |I have entered formula | =('L:\Quality Improvement Projects\2008\[2008 Advanced Directive | Monitor.xls]Summary by Provider'!c10) | | It does not bring the information from worksheet Summary by Provider to the | new worksheet. It just displays the formula in the cell. What am I doing | wrong. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula from one workbook/worksheet to another
Thank you, problem fixed.
"Niek Otten" wrote: The cell is probably formatted as text. Format as General and re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "SuziQ" wrote in message ... |I have entered formula | =('L:\Quality Improvement Projects\2008\[2008 Advanced Directive | Monitor.xls]Summary by Provider'!c10) | | It does not bring the information from worksheet Summary by Provider to the | new worksheet. It just displays the formula in the cell. What am I doing | wrong. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula from one workbook/worksheet to another
Thank you, It works now.
"Niek Otten" wrote: The cell is probably formatted as text. Format as General and re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "SuziQ" wrote in message ... |I have entered formula | =('L:\Quality Improvement Projects\2008\[2008 Advanced Directive | Monitor.xls]Summary by Provider'!c10) | | It does not bring the information from worksheet Summary by Provider to the | new worksheet. It just displays the formula in the cell. What am I doing | wrong. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| no of pages in excel worksheet (not workbook) | Excel Discussion (Misc queries) | |||
| Why can't you just Move a worksheet in Excel '07 to new workbook? | Excel Worksheet Functions | |||
| Formula needs to include several worksheet tabs in one workbook | Excel Discussion (Misc queries) | |||
| How do I take a cell in one worksheet and add it into the formula in a different worksheet in the same workbook? | Excel Worksheet Functions | |||
| Replace worksheet name in formula linked to a different workbook | Excel Discussion (Misc queries) | |||
Linear Mode
