Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2018, 09:34 PM
gkxcel gkxcel is offline Xcel xp closes when entering numeric data Windows 10 Xcel xp closes when entering numeric data Office XP
Novice
Xcel xp closes when entering numeric data
 
Join Date: Jun 2018
Posts: 4
gkxcel is on a distinguished road
Exclamation Xcel xp closes when entering numeric data

I am running xcel xp on a windows 10 computer. I was trying to add a hyper link to a workbook. When I tried to paste the link into the worksheet xcel closed. I tried several times with the same result. I did some testing and now I find that when trying to create a new work book xcel will close if I try to enter numeric data into two cells in the same row. I can add numeric data to more than one cell in the same column. If I open a work created previously to the start of the problem the problem does not occur.
If I add alpha/numeric data such as q23ft or 32wt56 to cells in the same row the problem does not occur.
Reply With Quote
  #2  
Old 06-29-2018, 10:52 PM
ArviLaanemets ArviLaanemets is offline Xcel xp closes when entering numeric data Windows 8 Xcel xp closes when entering numeric data Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Does this occur with every new workbook, or with one particular workbook created recently?

There can be various reasons of-course, but mostly it will be:
When this occurs only for you, and with every new workbook, then your Excel itself is corrupted. Repair or reinstall your MS Office;
When this occurs after last update, and for others too, and with every new workbook, then last Excel update was faulty. Take the update back;
When this occurs only for you single workbook, then your workbook is corrupted. Create it anew, or open the faulty workbook, open a new one too, and use PasteSpecial to copy formulas, values, formats, etc. into new workbook. Save the new workbook, test it, and when all is OK, delete the old one (and rename the new one).
Reply With Quote
  #3  
Old 06-30-2018, 08:35 AM
gkxcel gkxcel is offline Xcel xp closes when entering numeric data Windows 10 Xcel xp closes when entering numeric data Office XP
Novice
Xcel xp closes when entering numeric data
 
Join Date: Jun 2018
Posts: 4
gkxcel is on a distinguished road
Exclamation

I tried uninstalling and reinstalling Office xp. That did not cure the problem. I am the only one who uses the xcel files on my PC. I have no problem entering numeric data in more than one cell in the same row when adding data to one of my old workbooks,

I do experience a problem if I try to insert a link to the same or a different workbook.

If I create a new work book the problem with numerical data surfaces, It also surfaces if I try to inset a link from an older workbook into the new workbook.
Reply With Quote
  #4  
Old 06-30-2018, 11:07 AM
gkxcel gkxcel is offline Xcel xp closes when entering numeric data Windows 10 Xcel xp closes when entering numeric data Office XP
Novice
Xcel xp closes when entering numeric data
 
Join Date: Jun 2018
Posts: 4
gkxcel is on a distinguished road
Default xcel closing

More testing reveals that if I try placing any type of data(alpha, numeric , alpha/numeric) in a cell in a column after having previously entered numeric data to a cell in that column, xcel will close.
Reply With Quote
  #5  
Old 07-01-2018, 12:52 AM
ArviLaanemets ArviLaanemets is offline Xcel xp closes when entering numeric data Windows 8 Xcel xp closes when entering numeric data Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

It is difficult to guess what is causing this. Maybe you post here the full information about your Office - version number (the long one), 32 or 64 bit, are you using it in domain, are you creating a workbook on network resource or in your hard disk, etc. Then maybe there will be someone with build like yours, who can write how it works for him/her. When it is same, then it is Office problem, otherwise the cause is local.
Reply With Quote
  #6  
Old 07-01-2018, 08:34 PM
gkxcel gkxcel is offline Xcel xp closes when entering numeric data Windows 10 Xcel xp closes when entering numeric data Office XP
Novice
Xcel xp closes when entering numeric data
 
Join Date: Jun 2018
Posts: 4
gkxcel is on a distinguished road
Default

Excel 2002 (10.6871.6870) SP3 32 bit
Windows 10 Home 10.0.17134 Build 17134
Workbook created on my hard drive no network use
Reply With Quote
Reply

Tags
numeric data, xcel closes



Similar Threads
Thread Thread Starter Forum Replies Last Post
Some alpha/numeric data missing when I run MS Query Baldeagle Excel Programming 1 01-28-2015 01:00 PM
Xcel xp closes when entering numeric data colour codeing a cell by entering data gazza uk Excel 6 05-29-2014 09:52 AM
Xcel xp closes when entering numeric data entering data in separate rows within a cell drsuis Excel 1 02-19-2013 04:36 PM
Xcel xp closes when entering numeric data Sum Formula in the range with Numeric and NonNumeric data cells Spanec Excel 2 01-12-2012 09:15 AM
Automatically entering/fill data in cells in Excel 2003 dipdog Excel 0 08-17-2006 08:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:39 PM.


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