I have several, rather large, Excel files. When I open one I get a window that


says ..."Security Alert - Office File Validation"... . I am using Office 2007.

I did a Google search on it and get a lot of TechNo Babble that I don't understand.

How can I get rid of this pop up without major surgery ? It has only been
appearing since I upgraded to Windows 10.

Thanks,

rs

Generally speaking, that's a warning against opening the file. See: https://technet.microsoft.com/en-us/...or=-2147217396 . However, it may also be that your Windows 10 upgrade has damaged the Office installation.

You could try repairing the Office installation (via Excel Options|Resources|Diagnose).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I have a number of other Excel Files that do not cause this action.
It seems to be limited to this one file, which I created from scratch
a few years ago.

rs

As I said, you could try repairing the Office installation. It won't do any harm. If that doesn't resolve things, it's likely your problem file has content that Office legitimately warns you about (e.g. macros). Saving the file in the xlsx/xlsm format (as applicable) might resolve matters, as might changing one of Excel's Trust-Centre settings.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

No macros just plain text. I tried saving it to a new file, didn't do
anything to clear the warning box.

Also checked Trust Center Settings (all one of them !!), toggled it
on and off, no change.

Maybe this is MS's way of telling me to spring big bucks for an office
upgrade !!

rs

I very much doubt this has anything to do with the Office version. You still haven't indicated whether you've done a repair or saved the file in the in the xlsx/xlsm format - merely saving it as an xls file with a new name wouldn't change anything. And, of course, if you do save it in the xlsx/xlsm format, it's the new version of the file you'd have to test for error messages.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I saved the file in an xlsx format and I no longer get that warning. Now, explain to me why that happens and only with this one file ??

rs

The warning applies to files in the older xlsx format. Evidently Excel 2007 regarded something in that file as suspicious. You may even find that the warning doesn't recur if you save the xlsx file back to that format (in which case, there may have been some corruption in the file).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I tried saving it back to the previous format.
The pop up warning window came back.

rs