Dear Shashi, Please try through below link............it will be usefull for u.
http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html http://www.techrepublic.com/blog/10things/10-tips-for-working-more-efficiently-in-excel/203 another option....... 1. Save your file in .xlsb extension 2. Goto Windows Task Manager->Process->Image name>Select EXCEL.exe and right click Set Priority on High. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/> On Fri, Oct 28, 2011 at 2:31 PM, shashi <shashi2...@gmail.com> wrote: > Dear Noorain Sir > > I have some files whose file sizes is 10MB to 20 MB and when i open > these files in any version of office either 2003 or 2007 files is very > slow to open so is there any excel addin which can compress the size > or reduce the time of opening the file. > > > Thanks Sir > Shashi Ranjan > > > On Oct 27, 7:52 am, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote: > > Dear Indrajit, > > > > Please find attached Template,Hope it will be help to u. > > > > -- > > Thanks & regards, > > Noorain Ansari > > *http://excelmacroworld.blogspot.com/*< > http://excelmacroworld.blogspot.com/> > > *http://noorain-ansari.blogspot.com/*< > http://noorain-ansari.blogspot.com/> > > On Thu, Oct 27, 2011 at 1:01 AM, Indrajit $nai <talk2indra...@gmail.com > >wrote: > > > > > > > > > Hi All, > > > > > Can some one provide me some MIS template, like production analysis, > > > quality analysis (weekly, monthly and yearly basis)? It will be very > helpful > > > for me. > > > > > Thanks in advance. > > > > > -- > > > Indrajit > > > talk2indra...@gmail.com > > > > > Disclaimer: > > > This electronic message and any files transmitted with it are > confidential > > > and intended solely for the use of the individual or entity to whom > they are > > > addressed. If you are not the intended recipient you are hereby > notified > > > that any disclosure, copying, distribution or taking any action in > reliance > > > on the contents of this information is strictly prohibited and may be > > > unlawful. > > > > > -- > > > > > > ---------------------------------------------------------------------------------- > > > Some important links for excel users: > > > 1. Follow us on TWITTER for tips tricks and links : > > >http://twitter.com/exceldailytip > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > Like our page on facebook , Just follow below link > > >http://www.facebook.com/discussexcel > > > > > > > > Bobs-Homes(Dashboard).xlsx > > 50KViewDownload > > > > Copy of Dynamic Dashboard Illustration V1.1.xlsm > > 660KViewDownload > > > > Copy of KPI Dashboard - revisited II.xls > > 452KViewDownload > > > > project-status-dashboard-xl2007.xlsx > > 116KViewDownload- Hide quoted text - > > > > - Show quoted text - > > -- > FORUM RULES (925+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com