Formula too long

[Guest]

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

 

[JulieD]

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

 

[Dave Peterson]

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/[email protected]