Excel is changing my raw data

adam087

Well-known Member

Joined

Jun 7, 2010

Messages

1,356

• Nov 19, 2014

• #2

Can't replicate that :S
XL2010 Win7

/AJ

 

Upvote 0

C

ChadnHawaii

New Member

Joined

Jan 23, 2008

Messages

11

• Nov 19, 2014

• #3

Win7, Excel 2013

 

Upvote 0

Jonmo1

MrExcel MVP

Joined

Oct 12, 2006

Messages

44,061

• Nov 19, 2014

• #4

How exactly is the data input?
Are you typing it by hand, or copy/pasting it from somewhere?

Does it happen in all sheets/books ? Or just one/few in particular?

Do you have any Macros Running?
Try opening the book with Macros Disabled (Hold down shift key when you open it)

 

Upvote 0

J

James02

Board Regular

Joined

Nov 6, 2014

Messages

108

• Nov 19, 2014

• #5

Spreadsheet haunted?

 

Upvote 0

C

ChadnHawaii

New Member

Joined

Jan 23, 2008

Messages

11

• Nov 19, 2014

• #6

manual input
happens in all sheets
no macros touch the figure

I think haunted

 

Upvote 0

Jonmo1

MrExcel MVP

Joined

Oct 12, 2006

Messages

44,061

• Nov 19, 2014

• #7

ChadnHawaii said:

no macros touch the figure

Click to expand...

So reading between the lines, that means that there ARE macros...

Try opening the book with Macros Disabled by holding the Shift Key when you open it.
Does the issue still occur?

 

Upvote 0

C

ChadnHawaii

New Member

Joined

Jan 23, 2008

Messages

11

• Nov 19, 2014

• #8

it happens in a new worksheet without macros also

 

Upvote 0

Jonmo1

MrExcel MVP

Joined

Oct 12, 2006

Messages

44,061

• Nov 19, 2014

• #9

You're not really doing what I'm asking (or at least your responses are vague so I can't tell if you did or not)...

Just because the book you open doesn't have macros in it, doesn't mean there aren't macros running.

Hold down the shift key while you're opening a book.

 

Upvote 0

Jonmo1

MrExcel MVP

Joined

Oct 12, 2006

Messages

44,061

• Nov 19, 2014

• #10

My Apologies, Holding Shift doesn't seem to be a reliable method to disable macros.

Go to Optoins - Trust Center - Trust Center Settings - Macro Settings
Disable all macros without notification (this is temporary for troubleshooting)
Might also disable trusted locations and trusted documents.

 

Upvote 0