Hey Amit, use find and replace option "find value =" and "replace value '="................... and after past sheet again use find and replace function now new "find value '=" and "replace value ="
On Mon, Aug 29, 2011 at 1:08 PM, Amit Desai (MERU) <amit.de...@merucabs.com>wrote: > Dear Friends,**** > > ** ** > > Since the performance of excel was slow… & I have more than 1000 formula.. > **** > > ** ** > > I have opted for following**** > > ** ** > > **1) **Kept the formula only in first line & in following line made > all cells to value,**** > > **2) **The formulas in 4 sheets were linked to “sheet1”. Sheet1 was > every time refreshed by overwriting of fresh log entries. This was one of > the reason for slow performance. Now used to delete the sheet1 file & open > a fresh sheet naming “sheet1” paste the new log in it. However now cell > where in I had formula shows error as “#REF!”.**** > > **3) **I need to open the old file with formula & repaste the same on > first line of the each sheet in current file..**** > > ** ** > > Is there any way where in I can retain the formula even if the source data > is removed?**** > > ** ** > > Best Regards,**** > > Amit Desai**** > > *From:* Amit Desai (MERU) [mailto:amit.de...@merucabs.com] > *Sent:* Tuesday, August 23, 2011 7:0 > *To:* 'excel-macros@googlegroups.com' > *Subject:* RE: $$Excel-Macros$$ Very slow performance by Excel file**** > > ** ** > > Is it possible to write a macro..so that when I click on refresh, macro > will **** > > **1) **place the formula in each respective cells (all 1000 formulas > should be in its place)**** > > **2) **calculate the numbers,**** > > **3) **save the file.**** > > ** ** > > Best Regards,**** > > Amit Desai**** > > ** ** > > ** ** > > *From:* Amit Desai (MERU) [mailto:amit.de...@merucabs.com] > *Sent:* Tuesday, August 23, 2011 5:57 PM > *To:* 'excel-macros@googlegroups.com' > *Subject:* RE: $$Excel-Macros$$ Very slow performance by Excel file**** > > ** ** > > Done this …but system is still slow..**** > > ** ** > > Best Regards,**** > > Amit Desai**** > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Prakash Paul > *Sent:* Tuesday, August 23, 2011 5:03 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Very slow performance by Excel file**** > > ** ** > > Hi Amit, > > Try this method. > > Go to the task manager and set the excel.exe to high priority. > > Regards > Prakash Paul**** > > On Tue, Aug 23, 2011 at 4:56 PM, Amit Desai (MERU) < > amit.de...@merucabs.com> wrote:**** > > I have more than 1000 formulaes...spreaded in 4 sheets...pls suggest > solutions..**** > > > Best Regards, > Amit Desai > > Assistant Manager, Fleet MIS (Corporate) > Desk No.: 022 40520129 > Cell No.: 9867232534**** > > -----Original Message----- > From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com] > Sent: Saturday, August 20, 2011 6:05 PM > To: 'excel-macros@googlegroups.com'**** > > Subject: RE: $$Excel-Macros$$ Very slow performance by Excel file > > That's true. My memory usage shows more than 500 MB usage & my system's RAM > is 1GB!!! > > How can I get rid of this issue..I have put the excel formula caln as > manual..but still performance is very slow....**** > > Best Regards, > Amit Desai > > Assistant Manager, Fleet MIS (Corporate) > Desk No.: 022 40520129 > Cell No.: 9867232534**** > > -----Original Message----- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of XLS S > Sent: Friday, August 19, 2011 7:16 PM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Very slow performance by Excel file**** > > Try this... > > Go to "tools" -- "options" -- select "Calculation" tab -- check on > "manual" and make sure you check on "recalculate before save". this is > going reduce the time taken by excel to calculate the formulae present > in your sheet. hence increasing the performance. I'm sure that you > have lot of formulae in your sheet :-) > > On Fri, Aug 19, 2011 at 10:30 AM, Amit Desai (MERU) > <amit.de...@merucabs.com> wrote: > > Dear All, > > > > > > > > I have an excel sheet of about 700 rows & column till AZ. Because of the > > using formula the same is functioning very slowly. Is there any solution > to > > speed up the performance of file? > > > > > > > > My system's RAM is of 1 GB. > > > > > > > > Best Regards, > > > > Amit Desai > > > > > > > > Assistant Manager, Fleet MIS (Corporate) > > > > Desk No.: 022 40520129 > > > > Cell No.: 9867232534 > > > > > > > > ________________________________ > > Disclaimer: This message and its attachments contain confidential > > information and may also contain legally privileged information. This > > message is intended solely for the named addressee. If you are not the > > addressee indicated in this message (or authorized to receive for > > addressee), you may not copy or deliver any part of this message or its > > attachments to anyone or use any part of this message or its attachments. > > Rather, you should permanently delete this message and its attachments > (and > > all copies) from your system and kindly notify the sender by reply > e-mail. > > Any content of this message and its attachments that does not relate to > the > > official business of Meru Cab Company Pvt. Ltd. must be taken not to have > > been sent or endorsed by any of them. Email communications are not > private > > and no warranty is made that e-mail communications are timely, secure or > > free from computer virus or other defect. > > > > -- > > > > ---------------------------------------------------------------------------- > ------ > > 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 at http://www.excel-macros.blogspot.com > > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks at http://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 > > > > > > -- > ......................... > > -- > > ---------------------------------------------------------------------------- > ------ > 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 at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://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 > > > Disclaimer: This message and its attachments contain confidential > information and may also contain legally privileged information. This > message is intended solely for the named addressee. If you are not the > addressee indicated in this message (or authorized to receive for > addressee), you may not copy or deliver any part of this message or its > attachments to anyone or use any part of this message or its attachments. > Rather, you should permanently delete this message and its attachments (and > all copies) from your system and kindly notify the sender by reply e-mail. > Any content of this message and its attachments that does not relate to the > official business of Meru Cab Company Pvt. Ltd. must be taken not to have > been sent or endorsed by any of them. Email communications are not private > and no warranty is made that e-mail communications are timely, secure or > free from computer virus or other defect. > > -- > > ---------------------------------------------------------------------------------- > 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 at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://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**** > > ** ** > > -- > > ---------------------------------------------------------------------------------- > 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 at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://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**** > > ------------------------------ > Disclaimer: This message and its attachments contain confidential > information and may also contain legally privileged information. This > message is intended solely for the named addressee. If you are not the > addressee indicated in this message (or authorized to receive for > addressee), you may not copy or deliver any part of this message or its > attachments to anyone or use any part of this message or its attachments. > Rather, you should permanently delete this message and its attachments (and > all copies) from your system and kindly notify the sender by reply e-mail. > Any content of this message and its attachments that does not relate to the > official business of Meru Cab Company Pvt. Ltd. must be taken not to have > been sent or endorsed by any of them. Email communications are not private > and no warranty is made that e-mail communications are timely, secure or > free from computer virus or other defect. > > -- > > ---------------------------------------------------------------------------------- > 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 at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://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 > -- ......................... -- ---------------------------------------------------------------------------------- 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 at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://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