ntyburski
asked on
EXECEL - Does excel have a max file size??
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.??
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.??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hello ntyburski,any better now?
ntyburski:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
++++++++++++++++++++++++++
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Points split sebastienm & steve_randomno
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
MASQUERAID
EE Cleanup Volunteer - Applications
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Points split sebastienm & steve_randomno
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
MASQUERAID
EE Cleanup Volunteer - Applications
Is it something in your code that is perhaps hiding all the workbook? Is there an auto open module that runs code on entering? Does this code contain anything suspect?