if you can do then. 1. Clear all formatting you have done, and reformat all same(as was initial) cell in just one step. 2. try to avoid array formula 3. Before open file set calculation mode manual
Divaker On Fri, Jul 13, 2012 at 2:26 PM, pawel lupinski <lupins...@yahoo.com> wrote: > I'd like to do this but my knowladge is still not there, sad but true. > Maybe some other solution, please. > > Regards, > > Pawel > > *From:* Divaker Pandey <divake...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Friday, July 13, 2012 9:40 AM > *Subject:* Re: $$Excel-Macros$$ long opening file on the external server > > try to calculate required calculation with the help of macros. > > Divaker > > On Fri, Jul 13, 2012 at 12:14 PM, pawel lupinski <lupins...@yahoo.com>wrote: > > Hi All, > > I need your help on this issue. I have quite big file (21MB) that is doing > a lot of calculation between tabs, in order to run this file more efficient > I've switch off calculation, and I'm switch it on when needed. When I've > done this file on my computer its opening slowly but not so bad 10 sec. The > problem is: when I've put this file on company server for other users its a > nightmare. Yesterday I've been waiting to open about 6-10 min!!! I've > checked this on different workstation and the same opening time > unbelievable. > Do you have any thoughts? How Can I change this? What can improve it? > > Need your help > > Pawel > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > mailto:excel-macros%2bunsubscr...@googlegroups.com<excel-macros%2bunsubscr...@googlegroups.com> > > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- > FORUM RULES (986+ 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
