Home

After latest update Excel 2010 + PowerPivot cannot import text files

%3CLINGO-SUB%20id%3D%22lingo-sub-1171860%22%20slang%3D%22en-US%22%3EAfter%20latest%20update%20Excel%202010%20%2B%20PowerPivot%20cannot%20import%20text%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1171860%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20latest%20Office%202010%20updates%20I%20cannot%20use%20PowerPivot%20in%20Excel%202010%20to%20read%20text%20files.%20All%20my%20existing%20working%20apps%20now%20stopped%20working.%3C%2FP%3E%3CP%3ETo%20test%3A%20Start%20Excel%202010%2C%20Start%20PowerPivot%20and%20try%20to%20connect%20to%20existing%20.csv%20file.%3C%2FP%3E%3CP%3EError%20message%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3EAn%20error%20occurred%20while%20loading%20the%20file.%E3%80%80%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EMore%20Details%3AFailed%20to%20connect%20to%20the%20server.%20Reason%3A%20No%20error%20message%20available%2C%20result%20code%3A%20E_UNEXPECTED(0x8000FFFF).%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20rollback%20update%2C%20but%20there%20are%20just%20too%20many%20security%20updates%20on%20that%20day.%3C%2FP%3E%3CP%3EAny%20recommendations%20how%20can%20I%20recover%20from%20this%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1171860%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178258%22%20slang%3D%22en-US%22%3ERe%3A%20After%20latest%20update%20Excel%202010%20%2B%20PowerPivot%20cannot%20import%20text%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178258%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F556375%22%20target%3D%22_blank%22%3E%40Vidma2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello%2C%20if%20you%20have%20the%20capability%2C%20you%20can%20subscribe%20for%20Office%20365.%20Or%2C%20you%20can%20send%20Frown%20Feedback%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Abiola1_0-1581975074265.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171535iB382BB5C44053556%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Abiola1_0-1581975074265.png%22%20alt%3D%22Abiola1_0-1581975074265.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

After latest Office 2010 updates I cannot use PowerPivot in Excel 2010 to read text files. All my existing working apps now stopped working.

To test: Start Excel 2010, Start PowerPivot and try to connect to existing .csv file.

Error message:

An error occurred while loading the file. 

More Details:Failed to connect to the server. Reason: No error message available, result code: E_UNEXPECTED(0x8000FFFF).

 

I am trying to rollback update, but there are just too many security updates on that day.

Any recommendations how can I recover from this issue?

1 Reply
Highlighted

@Vidma2020 

 

Hello, if you have the capability, you can subscribe for Office 365. Or, you can send Frown Feedback

 

Abiola1_0-1581975074265.png