I have created an extremely interactive workbook with over 50 sheets and tons of vba, etc. Excel has already worned me that I have a max cell format limit of 4000. Which I figured out away around that! But now, my workbook is approximately 6MB and I am having trouble opening it. After I open the file and enter in the password to open the workbook, it acts as though it is opening but all i see is a default grey background. BUT, if I go to print preview I can see all of my sheets, etc, plus i can even print the entire workbook. So, my questios is:
Why CAN I see it in print preview, print it out, etc but NOT actually see the workbook or change anything?
I have already tried to debug excel, and reload MSO SR-1 Premium twice, and it is still doing it. Therefore, I beleive it has to be the file, and possible its size and not a program glitch.??