Excel was unable to open the file by repairing or removing the unreadable content

Hi
See how to troubleshoot to open files.XLSM with VBA Macros.
When you go to open the file, you receive the following error message:




"Excel was unable to open the file by repairing or removing the unreadable content.
Part Removed: part of/xl/VbaProject.bin. (Visual Basic for Applications (VBA)) "


Follow the step by step to solve this problem:

1. open Excel 2007.
2. click on the Office Button in the upper-left corner of the screen.
3. Access the "Excel Options", where he opened an advanced settings screen.
4. Select the option "add-ins", then select the option "VBA-analysis tool" that was to disabled and click the button "Go" at the end of the screen.
5. in the "add-ins", enable the feature "VBA-" analysis tool, click on the "OK" button and confirm the information that the feature was not installed and would like it to be made the installation by clicking "YES".

6. supplement "analysis tool-VBA" installed and enabled in Excel.

Comentários

Postagens mais visitadas deste blog

Como resolver o erro 0x00000040 TARGET_MDL_TOO_SMALL no Windows 10 e 11

Ativador Office 365 CMD - Como Ativar seu Office 365 em Poucos Passos

5 Comandos CMD para Otimizar o seu PC com Windows 10