Excel Formula from one workbook/worksheet to another

  • Thread starter Thread starter SuziQ
  • Start date Start date
S

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