Formula too long
 

I have several formulae that I need to make the same change too. I tried
Find-replace but got an error message saying the formula is too long.

So, I thought I would make the change manually but every time i press F2 or
click in the formula bar, Excel crashes.

I then pressed Ctrl+` so that I could paste the formula into Word, make the
change then paste it back. However, when I copy and paste it into Word, it
only pastes part of the formula, not all of it.

Anyone know how to get round this?

Thanks in advance

Hi Neil

without seeing your formula it's hard to tell ... but help says that
formula's are limited to 1024 characters, so if it's longer than that maybe
a different approach is needed.

If you'ld like to paste your "desired" formula with a bit of a description
about what you're trying to achieve maybe we can suggest other options.

Cheers
JulieD

"Neil_J" wrote in message
...
I have several formulae that I need to make the same change too. I tried
Find-replace but got an error message saying the formula is too long.

So, I thought I would make the change manually but every time i press F2
or
click in the formula bar, Excel crashes.

I then pressed Ctrl+` so that I could paste the formula into Word, make
the
change then paste it back. However, when I copy and paste it into Word,
it
only pastes part of the formula, not all of it.

Anyone know how to get round this?

Thanks in advance

I'm not sure if this'll stop excel from crashing (I've never seen that happen
when I do what you're doing):

http://groups.google.co.uk/groups?th...apeXSPAM.c om


Neil_J wrote:

I have several formulae that I need to make the same change too. I tried
Find-replace but got an error message saying the formula is too long.

So, I thought I would make the change manually but every time i press F2 or
click in the formula bar, Excel crashes.

I then pressed Ctrl+` so that I could paste the formula into Word, make the
change then paste it back. However, when I copy and paste it into Word, it
only pastes part of the formula, not all of it.

Anyone know how to get round this?

Thanks in advance

--

Dave Peterson