are using formula in sheet?, i hope there are refrences of some other files.
On Thu, May 23, 2013 at 5:49 PM, P.VIJAYKUMAR <vijay.4...@gmail.com> wrote: > Respected Prabhu, > > You are saying that the sheet is companies sheet.Is is password protected > or are any user rights restricted to used and to modify or make any changes > to the file.Check also for version based compatibility issues because > earlier version had lower data input and processing capabilities compared > to the latest versions.Increasing you systems processor speed may also > solve the problem.If you do not have much data in the file crate a fresh > file with the same data because many time by some error the file gets > corrupted and the new file works perfectly alright without any problems.To > know how much processing memory and time is consumed by excel during the > stuck time start the Task manager and go to processes tab and search for > excel in the process. I think the processing time and memory used will be > more during that period.the problem can only be dealt with specifically if > only we know what exactly is causing the problem. > > Regards, > VIJAYKUMAR > > > On Thu, May 23, 2013 at 5:23 PM, Prabhu Pinky <prabhupin...@gmail.com>wrote: > >> No david..that sheet contains no macros, even very less formula. Only the >> thing is some cells have formatted... >> >> Prabhu R >> On May 23, 2013 5:20 PM, "David Grugeon" <da...@grugeon.com.au> wrote: >> >>> Also do you have macros which are run when changes are made to the >>> sheets. It may be possible to reorganise them so they run faster or are >>> not triggered so readily. >>> >>> Regards >>> David Grugeon >>> >>> >>> >>> On 23 May 2013 21:47, David Grugeon <da...@grugeon.com.au> wrote: >>> >>>> Try setting the calculation to Manual. Then see if Cut and Paste still >>>> takes a lot of time. It could be that there are a lot of formulas having >>>> to be recalculated when there is a change to the worksheet. If this is >>>> identified as the cause you may be able to get a gain by redesigning hr >>>> worksheets, or by keeping calculation turned off and pressing F9 when you >>>> want it to calculate. >>>> >>>> Regards >>>> David Grugeon >>>> >>>> >>>> >>>> On 23 May 2013 21:26, Prabhu Pinky <prabhupin...@gmail.com> wrote: >>>> >>>>> thanks vijay, lemme try this too. >>>>> >>>>> but my doubt is if already "Use all the processors on this computer" >>>>> option is selected. then..? >>>>> >>>>> >>>>> Regards, >>>>> Prabhu R >>>>> >>>>> >>>>> >>>>> On 23 May 2013 16:48, P.VIJAYKUMAR <vijay.4...@gmail.com> wrote: >>>>> >>>>>> Respected Prabhu, >>>>>> >>>>>> Please go to excel options button and from there go to the advanced >>>>>> tab and under that go to the formulas section.The third point will >>>>>> contain >>>>>> how many processors are used for excel calculations.check the radio >>>>>> button >>>>>> to use all the processors for calculations.This may boost up ur speed a >>>>>> little bit.There may be various other reasons for slowness of the >>>>>> processes >>>>>> like compatibility issues,macros errors or virus etc.I frequently face >>>>>> this >>>>>> problem when the workbook contains plenty of calculations and number of >>>>>> sheets and every small step even a copy and format takes many minutes to >>>>>> accomplish. >>>>>> >>>>>> Regards, >>>>>> Vijaykumar >>>>>> >>>>>> >>>>>> On Thu, May 23, 2013 at 4:15 PM, Prabhu Pinky <prabhupin...@gmail.com >>>>>> > wrote: >>>>>> >>>>>>> Hi Abhishek : thanks for the idea. i will try this one. >>>>>>> >>>>>>> >>>>>>> David : i am unable attach the file, because it is violation in our >>>>>>> office. >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> On 23 May 2013 13:39, David Grugeon <da...@grugeon.com.au> wrote: >>>>>>> >>>>>>>> Can't guess without seeing the file. Can you attach it? >>>>>>>> >>>>>>>> Regards >>>>>>>> David Grugeon >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On 23 May 2013 16:49, Prabhu Pinky <prabhupin...@gmail.com> wrote: >>>>>>>> >>>>>>>>> Hi experts, >>>>>>>>> I have one excel file. Size is below 1mb. Even though it is very >>>>>>>>> slow working in that file. If I do copy paste any single cell, it >>>>>>>>> takes too >>>>>>>>> much time. >>>>>>>>> >>>>>>>>> What could be the reasons...? >>>>>>>>> >>>>>>>>> Prabhu R >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna >>>>>>>>> be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this >>>>>>>>> forum @ >>>>>>>>> https://www.facebook.com/discussexcel >>>>>>>>> >>>>>>>>> FORUM RULES >>>>>>>>> >>>>>>>>> 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) Jobs posting is not allowed. >>>>>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>>>>> >>>>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum >>>>>>>>> owners and members are not responsible for any loss. >>>>>>>>> --- >>>>>>>>> You received this message because you are subscribed to the Google >>>>>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>>>> send an email to excel-macros+unsubscr...@googlegroups.com. >>>>>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>>>>> . >>>>>>>>> Visit this group at >>>>>>>>> http://groups.google.com/group/excel-macros?hl=en. >>>>>>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna >>>>>>>> be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this >>>>>>>> forum @ >>>>>>>> https://www.facebook.com/discussexcel >>>>>>>> >>>>>>>> FORUM RULES >>>>>>>> >>>>>>>> 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) Jobs posting is not allowed. >>>>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>>>> >>>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum >>>>>>>> owners and members are not responsible for any loss. >>>>>>>> --- >>>>>>>> You received this message because you are subscribed to the Google >>>>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>>> send an email to excel-macros+unsubscr...@googlegroups.com. >>>>>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>>>>> Visit this group at >>>>>>>> http://groups.google.com/group/excel-macros?hl=en. >>>>>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>>>> https://www.facebook.com/discussexcel >>>>>>> >>>>>>> FORUM RULES >>>>>>> >>>>>>> 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) Jobs posting is not allowed. >>>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>>> >>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>>>> and members are not responsible for any loss. >>>>>>> --- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to excel-macros+unsubscr...@googlegroups.com. >>>>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>>>> Visit this group at >>>>>>> http://groups.google.com/group/excel-macros?hl=en. >>>>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> P.VIJAY KUMAR >>>>>> >>>>>> -- >>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>>> https://www.facebook.com/discussexcel >>>>>> >>>>>> FORUM RULES >>>>>> >>>>>> 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) Jobs posting is not allowed. >>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>> >>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>>> and members are not responsible for any loss. >>>>>> --- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to excel-macros+unsubscr...@googlegroups.com. >>>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en >>>>>> . >>>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>>> >>>>>> >>>>>> >>>>> >>>>> -- >>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>> https://www.facebook.com/discussexcel >>>>> >>>>> FORUM RULES >>>>> >>>>> 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) Jobs posting is not allowed. >>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>> >>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>> and members are not responsible for any loss. >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to excel-macros+unsubscr...@googlegroups.com. >>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>> >>>>> >>>>> >>>> >>>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 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) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 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) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > > > -- > > > > > > > > > > P.VIJAY KUMAR > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
