Is it just this file which is slow or are all excel files slow? Is this file slow if you run it on another computer? What is the file extension? Xls, xlsb, xlsm,xlsb. What version of windows? Including whether it is 32 or 64 bit? What version of office? Also 32 or 64 How much memory does the computer have? Is the excel program run from your computer or from a server? E.g. If you have a thin client. Is your swap file fixed or variable size? If fixed what is the maximum size? Are there other programs running on your computer that could be slowing it down? Look at CPU usage in task manager. Are there any macros in your personal.xls(m) whic could be running repeatedly?
I hope the answer to one of these questions helps to pinpoint the problem. On Friday, 24 May 2013, Prabhu Pinky wrote: > But my bad time..even I copied the data which contains formula and formats > into new sheet. Same problem I face.... I copied the cell which contains > only the data... > > Prabhu R > On May 23, 2013 9:41 PM, "Bé Trần Văn" <betnmtdongna...@gmail.com> wrote: > > Maybe because your spreadsheet data using multiple functions, or select > and delete the blank column on the right, select and delete the blank line > underneath the sheet containing the data, if not all slow sluggish, the > ultimate > solution is a new file, open 1, copy each sheet and select Paste Special > Values and click OK. > > 2013/5/23 Divaker Pandey <divake...@gmail.com> > > are using formula in sheet?, i hope there are refrences of some other > files that may be closed. it may reason you file taking more time to > calculate. > > > > > On Thu, May 23, 2013 at 8:05 PM, Divaker Pandey <divake...@gmail.com>wrote: > > 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 > > -- Regards David Grugeon -- 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.
