Office costing me a lot of time.
2 problems:

1. excel, graphs loosing there formatting eg. going from "date"
formatting to "4E+04" formatting.

2. this is a major problem...
graphs are changing there own source data locations eg. from "data
range" to "series" and if you click back to the data range tab it pops
up with an error saying...
***Referance not valid. Referance must be to an open worksheet***
Doesn't make sense as it actually should be refering to information
that's in the page thats open and I am working on.


(Just in case this helps (if there's some sort of strange office
glitch) I also have minor problem in word, I can normally cut and paste
images into word but they are coming up blank. the space is there where
the image should be but no actual picture. If that's related to the
Excel probs I don't know, doubt it but you never know).

The Excel probs are urgent and important as this is part of my everyday
job function and I heavily rely on excel spreadsheets and graphs.

I am using a Dell Optiplex GX280 running Win XP Pro using Excel 2002.


PLEASE HELP ME!!!!

Thanks,
John Hamer



--
JohnHamer
------------------------------------------------------------------------
JohnHamer's Profile: http://www.excelforum.com/member.php...o&userid=27471
View this thread: http://www.excelforum.com/showthread...hreadid=469835