A co-worker opened an existing workbook she authored. She noticed that all of
the Column Headers were numeric, like the Row Headers. All worksheets within
the workbook are like this. With this arrangement, she cannot enter formulas
because of the conflicts in range/cell identification. I checked out the
'Options' under the Tools dropdown and there wasn't anything in there that
looked 'abnormal". Any ideas or suggestion?

Thanks!
Mark

Tools/options/general tab remove the tick in the r1c1 reference
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Mark Bursian" wrote:

> A co-worker opened an existing workbook she authored. She noticed that all of
> the Column Headers were numeric, like the Row Headers. All worksheets within
> the workbook are like this. With this arrangement, she cannot enter formulas
> because of the conflicts in range/cell identification. I checked out the
> 'Options' under the Tools dropdown and there wasn't anything in there that
> looked 'abnormal". Any ideas or suggestion?
>
> Thanks!
> Mark

Excellent! That worked perfectly! I overlooked that option. Thank you very
much.

"john" wrote:

> Tools/options/general tab remove the tick in the r1c1 reference
> --
> John
> MOS Master Instructor Office 2000, 2002 & 2003
> Please reply & rate any replies you get
>
> Ice Hockey rules (especially the Wightlink Raiders)
>
>
> "Mark Bursian" wrote:
>
> > A co-worker opened an existing workbook she authored. She noticed that all of
> > the Column Headers were numeric, like the Row Headers. All worksheets within
> > the workbook are like this. With this arrangement, she cannot enter formulas
> > because of the conflicts in range/cell identification. I checked out the
> > 'Options' under the Tools dropdown and there wasn't anything in there that
> > looked 'abnormal". Any ideas or suggestion?
> >
> > Thanks!
> > Mark

Your welcome

There are soooo many options they are easy to miss
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Mark Bursian" wrote:

> Excellent! That worked perfectly! I overlooked that option. Thank you very
> much.
>
> "john" wrote:
>
> > Tools/options/general tab remove the tick in the r1c1 reference
> > --
> > John
> > MOS Master Instructor Office 2000, 2002 & 2003
> > Please reply & rate any replies you get
> >
> > Ice Hockey rules (especially the Wightlink Raiders)
> >
> >
> > "Mark Bursian" wrote:
> >
> > > A co-worker opened an existing workbook she authored. She noticed that all of
> > > the Column Headers were numeric, like the Row Headers. All worksheets within
> > > the workbook are like this. With this arrangement, she cannot enter formulas
> > > because of the conflicts in range/cell identification. I checked out the
> > > 'Options' under the Tools dropdown and there wasn't anything in there that
> > > looked 'abnormal". Any ideas or suggestion?
> > >
> > > Thanks!
> > > Mark