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 com
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" wrote:
> Maybe because your spreadsheet data using multiple functions, or select
>
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 Specia
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 wrote:
> are using formula in sheet?, i hope there are refrences of some other
> files.
>
>
> O
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 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 a
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 capabili
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" 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 r
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 wrote:
> Try setting the calculation to Manual. Then see if Cut and
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
worksheet
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 wrote:
> Respected Prabhu,
>
> Please go to excel options button and from there go to the advanced tab
> an
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
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 wrote:
> Can't guess without seeing the file. Can you attach it?
>
> Regards
> David Grugeon
>
>
>
> On 23 May 2013 16:49,
Can't guess without seeing the file. Can you attach it?
Regards
David Grugeon
On 23 May 2013 16:49, Prabhu Pinky 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.
Not sure if this is your case but:
Press F5 > Special > Objects and if Excel finds anything, press Delete.
Might help.
On Thu, May 23, 2013 at 12:19 PM, Prabhu Pinky 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
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,
DEAR EXPERTS ,
HOW TO DO THAT WITHOUT PIVOT TABLE.HOW TO MAKE PAGE BREAK AFTER ONE CODE &
RNAME & RELEVANT DATA
HOW TO FIX FIXED DATA IN FOOTER OF THE PAGE IN EXCEL SO THAT IT COMES IN
EVERY PAGE
REGARDS
JITENDER
--
-
16 matches
Mail list logo
