opening files in excel

  anjay 09:56 05 Feb 06

In Windows XP prof I have OFFICE 02
McAffee anti-virus and Spyware doctor
Various word files and excel files together with graphics under Serif and Photo Shop
After a session of normal use, quite suddenly I am met with message
Cannot open file.
After clicking twice on this message, the file opens and behaves normally.
Sometimes there is a further message :
There are macros on this file: Disable or allow ??
On either action the file opens normally.
The complete computer files have been scanned by both Macaffee an by Spydoctor (both upgraded) and no viruses etc have shown up

Both Office and Windows have been re-installed t no effect.
Is the anything I can do other than removing Office and Windows and re-formatting ?

  Taff™ 10:45 05 Feb 06

Two things come to mind, the first being security, Tools>Macros>Security. From here you can set the security level - yous sounds as if it`s on Medum because it`s asking you to decide whether to open files with macros, no necessarily a bad thing though.

Secondly try a repair of Excel. Help>Detect & Repair - you may be asked for your installation disk for Ofice 2002.

  anjay 12:32 05 Feb 06

Regret to say all these have been well & truly tried with no joy
Will I have to re-format all ??

  Taff™ 23:34 05 Feb 06

I would play about witht the settings some more yet. You`ve already tried fresh installs of both Windows and Office so doing it again won`t help. Which Service Pack are you using on Windows?

  anjay 11:46 06 Feb 06

The shorth answer is updated 2

  anjay 09:38 08 Feb 06

Are we at the end of the road??

  anjay 17:56 09 Feb 06

This query has not been resolved

  anjay 18:00 09 Feb 06


This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…