• 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.

What does this entry mean?

rsomist

Member
I have a worksheet that someone gave me and in cells A38 - A43, that have the text:

$$NICU
$DRG/3
$DRG/1
$DRG/2
$DRG/5
$DRG/6

This text is not with the intent of being a function or anything other than just text, but anytime you click on any cell in one of these rows, blue lines come up around the entire section, a Sparklines contextual tab appears, and Excel stops responding. Has this person inadvertently entered in some sort of function that is causing Excel to not respond?
 
Hi,

It is hard to say without looking at the file... but there may be some code behind it that is being triggered by the selection of those cells.
Or something else entirely :)

If possible upload the file and I'm sure someone will be able to help out.
 
Perhaps it is corrupted somehow... on my end it started to become unresponsive the moment I opened it, not just when selecting those cells.
Since this is a file saved as binary, there could definitely be some code behind it, although I couldn't find anything.

Sorry
 
I know it has to do with rows 38-43 because once I can (eventually - very long process) get them deleted, the whole program starts responding normally again. I didn't know if it might have something to do with the $ and / being used - maybe Excel is trying to perform a function that isn't possible and causing it to be non-responsive?
 
I know it has to do with rows 38-43 because once I can (eventually - very long process) get them deleted, the whole program starts responding normally again. I didn't know if it might have something to do with the $ and / being used - maybe Excel is trying to perform a function that isn't possible and causing it to be non-responsive?
I honestly have no clue :(
 
Back
Top