Error: "Opening This Excel 2003 File may be Dangerous." ??

[monirg]

Hello;

1) I've been using this XL 2003 (complex) Read-Only file for years with no problem whatsoever.
I developed it about 4 yrs ago, and I believe last time I opened it was about a month or two ago on the same computer with the same Excel 2003.
There have been no hardware or software changes.

2) I tried earlier today to open the file.
After the usual Security Warning "Enable Macros", the following message was displayed:

" Microsoft Excel
Office File Validation detected a problem while trying to open the file.
Opening it may be dangerous."

with two options: "Open" and "Cancel".
Needless to say, I froze for a moment and quickly chose "Cancel".
I repeated the process few times with the same result.

Can someone please help or advise on what to do ??

Thank you kindly.

 

[RoryA]

My first suggestion would be to remove the Office File Validation update that came out recently as it causes all sorts of problems.

 

[monirg]

Hi Rory;

Thank you kindly for your prompt and helpful reply.

Will shortly apply Method 4, and try to fix the problem automatically by clicking the link "Fix it for me" in:
http://support.microsoft.com/kb/2570623

Keep in mind, there's no networking involved.

Regards.

 

[monirg]

Hi Rory;

1) I've tried:
--> Method 3: Microsoft Fix it 50748
and
--> Method 4: Microsoft Fix it 50741
to disable the Microsoft Office File Validation.

2) Both methods produced:

There is a problem with Windows Installer package.
A script required for this install to complete could not be run.
Contact your support personnel or package vendor.

Any suggestion ??

Regards.

 

[Peter_SSs]

Any suggestion ??

Yep, follow Rory's first suggestion ..

My first suggestion would be to remove the Office File Validation update

 

[monirg]

Hi Peter;

follow Rory's first suggestion ..

That was exactly what I did.
I followed Rory's suggestion and tried both Method 3 & Method 4, described at:
http://support.microsoft.com/kb/2570623
and tried to fix the problem automatically by clicking the link "Fix it for me".

As I reported in my previous reply:

Both Methods produced:
"There is a problem with Windows Installer package.
A script required for this install to complete could not be run.
Contact your support personnel or package vendor."

Have I missed something in Rory's reply ??

Regards.

 

[Peter_SSs]

Hi Peter;
That was exactly what I did.
I followed Rory's suggestion and tried both Method 3 & Method 4, described at:
http://support.microsoft.com/kb/2570623
and tried to fix the problem automatically by clicking the link "Fix it for me".

As I reported in my previous reply:
Have I missed something in Rory's reply ??

Regards.

I think that Rory's suggestion was to physically remove the installed update from your machine, not to try to tweak it so the problem was lessened. That is certainly what we did at my workplace when we encountered this problem. I could be wrong but I think the link Rory provided was mainly to point out that this update can cause problems, not to suggest that you followed those instructions.

 

[monirg]

Hi Peter;

Thanks again for your prompt and helpful reply.
Could you please elaborate a little on how to:

... physically remove the installed update

1. what is the ref name(s) of the OFV update(s) ??
2. is it a name or a KB# I should locate ??
3. where do I find the relevant update(s) in the system ??
4. is it a single file "Delete" or "Control Panel/Remove Program" ??
5. would removing the OFV update(s) affect other components of Office 2003 ??
6. can I surgically remove the OFV update(s) that only affect Excel 2003 ??
7. do you (or someone in your office) recall (hopefully, step-by-step) how it was done earlier at your workplace ??
8. should I try the 12-step "Let me fix it myself" outlined at:
http://support.microsoft.com/kb/2570623

Any help you can provide would be greatly appreciated and acknowledged.
I'm absolutely stuck and don't want to find myself in a deeper hole by trying something haphazardly and regret the consequences.

By the way, there's no networking involved, and the problem appears to be limited to that single complex XL 2003 file (~3.0 MB) mentioned in my OP.
Also, no other version of Excel is installed on that computer.

Thank you kindly.

 

[Peter_SSs]

Monir

I don't remember all those exact details and this is an area I don't wish to give specific & detailed advice on since systems can vary so much. However, I think if you Google something like "remove microsoft office file validation" you should find quite a few hits and hopefully something will suit your circumstances.

 

[RoryA]

Have you tried simply opening the file?