An excel file in not opening as its original view in-spite of this it is showing "Too many cell?

I think, your excel files are corrupted, due to virus affected and any other reason.

"Excel files can live a sever time, being upgraded from version to version and move from one PC to another PCs. Sever times the user that have inherited the file don't know what's included in the file. Taking an inventory of the file and removing items out that are no longer needed will lengthen the life of the file. "

I would like suggest more reliable & effective excel file recovery software, you can use third-party software Kernel for Excel File Repair Tool. That application quickly recover and repair corrupt, damage excel files.