2007 Excel doing strange things?

basils57

New member
Member
VIP
Local time
4:53 PM
Messages
150
I wonder if anyone can advise on the following please?

I have a long standing workbook in which one particular worksheet has suddenly started to operate strangely - when I insert figures into a column which is set up to be auto-summed, as soon as the second number is entered the sum becomes what appears to be a combination of the two numbers overlaid upon each other. Any consequent calculation involving that cell in say the row, also takes on the 'overlay' appearance.

I have tried test auto-sum etc on other worksheets in the same book and it would appear that the problem lies with this one sheet. It is confusing me, does anyone have any ideas please|?
 

My Computer

Computer type
PC/Desktop
OS
Windows 7 Home Premium 64bit.
CPU
Intel Core i5-2500k Quad @ 3.3GHz
Motherboard
ASUSTeK P8Z68-V LE (LGA1155)
Memory
8.00 GB Dual-Channel DDR3 @ 666.7MHz (5-5-5-15)
Graphics Card(s)
PL2773HDs on AMD Radeon HD 6600 Series
Monitor(s) Displays
Llyama PL2773HDS
Screen Resolution
1920x1080 pixels
Hard Drives
SAMSUNG HD103SJ ATA Device 1TB
Hi,

Can you attach a cut-down version of the spreadsheet, and I'll have a look for you?

Regards,
Golden
 

My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Golden Mk. I.4
OS
Windows 10 Pro x64 ; Xubuntu x64
CPU
Intel i7 860 @ 2.80 GHz O/C'ed to 4.0GHz
Motherboard
Gigabyte P55A-UD3R Rev.1. Award BIOS F13
Memory
16GB Corsair Vengance DDR3 @ 661 MHz Dual Channel (9-9-9-24)
Graphics Card(s)
EVGA NVidia GTX 560 1024MB
Sound Card
Realtek Integrated
Monitor(s) Displays
Dual Samsung SyncMaster 2494HS
Screen Resolution
1920*1080 and 1920*1080
Hard Drives
1*Samsung 840 EVO 120GB SSD;
1*OCZ Vertex 2 60GB SSD;
2*Samsung F3 SpinPoint 1TB in RAID0;
1*Samsung F1 SpinPoint 1TB;
2*Western Digital 1TB External USB 3.0
1*Western Digital 500GB External USB 3.0
1*Seagate 500GB External USB 2.0
PSU
Thermaltake ToughPower QFan 750W
Case
Thermaltake Element S VK60001W2Z
Cooling
Corsair H60 Water Cooling, 2*230mm and 2*80mm case fans
Keyboard
Logitech G110
Mouse
Logitech MX518
Back
Top