Excel Formula from one workbook/worksheet to another

[SuziQ]

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.

 

[Niek Otten]

The cell is probably formatted as text.
Format as General and re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|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.

 

[SuziQ]

Thank you, problem fixed.

 

[SuziQ]

Thank you, It works now.