• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IN EXCEL WORKBOOK ONE SHEET IS WORKING FAST BUT ANOTHER NOT

S

SAMRAT

New Member
IN MY EXCEL WORKBOOK WHICH I DEVELOPED FOR TIME MANAGEMENT IN THAT ONE SHEET IS WORKING FAST BUT ANOTHER NOT WHY???? GIVE ME SOLUTION IT TAKE TIME WHEN I PRESS ENTER TO RESPONSE
 
1. Please stop yelling at us

2. Read the stickey about forum rules. It'll tell you the proper etiquette to use

3. I'm guessing the 2 sheets are very different. Changing the value of a cell that's not got any formulas referencing it is easy. Changing a cell that is referenced in over 100,000 cells causes a lot more work.


Simple solution: The 2nd sheet is having to work harder.


If you stop yelling, I'd encourage you to post back with more details about your situation so we can try and help you out more.
 
thanks for reply


i don't understand it, but the sheet which i having problem contain near around 1000 to 1500 cell formatted with 6-7 conditional formatting rules and also 12 hyperlink within sheet
 
The hyperlinks won't have an affect on the calculation time, but the conditional formatting certainly could. For some general ideas on how to help speed things up, I'd recommend starting here:

http://dmcritchie.mvps.org/excel/slowresp.htm
 
You must log in or register to reply here.
Back
Top