Locking cells

[Bourgeois]

how do you remove the dollar sign from a link.

See example,

='[Mat Leave Summary.xls]Mar 2009'!$P$23

All of a sudden, all my formulas have this dollar sign in the equation?

 

[VoG]

If you have a lot to do try ASAP Utilities http://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=102&utilities=Formula

 

[Bourgeois]

We are not allowed to download and install new programs, is there another way?

 

[VoG]

Try this http://www.ozgrid.com/VBA/formula-ref-change.htm

 

[Smitty]

That happens when you link to an external workbook. When you're entering the formula, you can hit F4 on this part $P$23 to toggle absolute references.

For exisitng formulas you can use Find & Replace. Find-->$ Relace with nothing.

HTH,