The file is extremely big despite simple formula. I only used some simple countif functions. However, some of the data are downloaded from another website. Would there be something in there that makes the file so large?
https://www.sendspace.com/file/bs9ax9
Thanks!
My browser is warning me against downloading from this site. I think you are going to have to find another way to give us access to this file.
warning.png
There were formulas that went the whole length of the sheet (over 1 million rows) and other things like that. I deleted all the formulae below your actual data and eliminated all excess formatting. The file is dramatically smaller. I changed the ranges to tables and that will carry down the columns the formulae that you have as they are needed and not fill up your file with formulae waiting for data.
If this format is not something that you can work with, change the tables back to ranges but only fill the formulae down the columns a few rows further than you immediately need.
I hope that this solves your problem without causing problems.
Last edited by newdoverman; 05-31-2015 at 08:52 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks