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

Reply via email to