Excel Simple question, but i need an answer

[q4s72534]

i want to copy formulas from one workbook to the other w/o the formulas linking to the old workbook.


example:
Workbook1
=gl*5

When i copy the formula over to workbook2 it says
Workbook2
=[workbook1]!gl*5

i want it to copy over like this
=gl*5

 

[Loomah]

One solution would be to copy what you want then do a find and replace on the workbook name - replace "[workbook1]!" with ""
;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[q4s72534]

so you can do a find replace for functions as you would for visible text. hmmm... i'll try it.

 

[xlbo]

Just set the option to look in Formulas rather than values

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[JohnAcc]

Or you could Copy and then Paste Special as Formulas ?

Rgds, John

Work is the curse of the drinking classes.......