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.

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.

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.

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.