Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-05-2018, 02:54 PM
Phil H Phil H is offline Data entry error in individual cell Windows XP Data entry error in individual cell Office 2010 64bit
Advanced Beginner
Data entry error in individual cell
 
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 11-06-2018, 01:30 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Data entry error in individual cell Windows 7 64bit Data entry error in individual cell Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,780
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 11-06-2018, 04:23 AM
Phil H Phil H is offline Data entry error in individual cell Windows XP Data entry error in individual cell Office 2010 64bit
Advanced Beginner
Data entry error in individual cell
 
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default

Will do when I get a response to my question. Thanks for the help.
Reply With Quote
  #4  
Old 11-06-2018, 04:44 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Data entry error in individual cell Windows 7 64bit Data entry error in individual cell Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,780
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #5  
Old 11-06-2018, 04:51 AM
Phil H Phil H is offline Data entry error in individual cell Windows XP Data entry error in individual cell Office 2010 64bit
Advanced Beginner
Data entry error in individual cell
 
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default

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.
Reply With Quote
Reply

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
Data entry error in individual cell Using Vlookup_value is a table not an individual cell? ms2007 Excel 3 09-20-2016 09:47 AM
Data entry error in individual cell 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:51 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft