#1
|
|||
|
|||
Data entry error in individual cell
I have a cell that accepts values => a numeric value of 105. Anything else causes an error: "Microsoft Excel has encountered a problem and needs to close....." It asks if I want to send a report - I tried, but got no response. When clicking the More Information button, I get:
Microsoft Error Reporting log version: 2.0 Error Signature: Exception: EXC_BAD_ACCESS Date/Time: 2018-11-05 21:48:52 +0000 Application Name: Microsoft Excel Application Bundle ID: com.microsoft.Excel Application Signature: XCEL Application Version: 14.7.2.170228 Crashed Module Name: Gfx Crashed Module Version: 14.7.2.170228 Crashed Module Offset: 0x0013ddf3 Blame Module Name: Gfx Blame Module Version: 14.7.2.170228 Blame Module Offset: 0x0013ddf3 Application LCID: 1033 Extra app info: Reg=en Loc=0x0409 Crashed thread: 0 No other cells were found with this problem. Can anyone tell me what's going on? |
#2
|
||||
|
||||
Please post your worksheet
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Will do when I get a response to my question. Thanks for the help.
|
#4
|
||||
|
||||
I suppose seeing the sheet will help answer your question?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
There is nothing unusual about the worksheet. In fact, the cell in question worked properly in the previously-saved version of the workbook. Maybe there is a corruption in the cell. I can always recreate (make a copy) the error-cell work sheet to see if the error clears. I don't understand the text in the error information provided by the application so I brought it to this forum thinking an expert would recognize the error and provide advice.
BTW I cannot provide the workbook online as it has confidential financial information. |
Tags |
data entry error |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Allow Entry In Cell Based On Value In Another Cell | koltanga | Excel | 1 | 05-07-2017 10:26 AM |
Using Vlookup_value is a table not an individual cell? | ms2007 | Excel | 3 | 09-20-2016 09:47 AM |
How to have one cell show a value based on the entry of another cell? | Marvinapplegate1964 | Excel | 1 | 05-04-2016 01:49 PM |
Extracting multiple words from one cell into individual rows while copying all other data | randyaserve | Excel Programming | 4 | 10-05-2015 09:52 AM |
Error when creating a calendar entry with VBA | mbodunov | Outlook | 0 | 03-10-2011 11:21 PM |