x404.co.uk http://www.x404.co.uk/forum/ |
|
Confusing Excel auto replace http://www.x404.co.uk/forum/viewtopic.php?f=4&t=2113 |
Page 1 of 1 |
Author: | big_D [ Tue Aug 04, 2009 1:32 pm ] |
Post subject: | Confusing Excel auto replace |
I have a user with an Excel spreadsheet (2007), which automatically replaces his name in one column, but not the rest of the sheet! I've had a look at the formatting of the cell and it has standard (I changed it to Text, but no difference)... I can't see any auto-texts applied to the cell. Basically, if he types "Badziong" into column B, it gets replaced with "Bath", but if he types it into columns A, C, D, E etc. it stays as-is. We tried changing it to "Hr. Badziong", which works as a temporary fix, but I'd like to find out why it is doing it... |
Author: | AlunD [ Tue Aug 04, 2009 1:36 pm ] |
Post subject: | Re: Confusing Excel auto replace |
Sounds like conditional formatting in column B. select a cell in B and on teh home tab select conditional formatting . |
Author: | big_D [ Tue Aug 04, 2009 1:42 pm ] |
Post subject: | Re: Confusing Excel auto replace |
Cool, he is gone for the day, I'll try it out tomorrow and let you know how I get on. |
Author: | big_D [ Wed Aug 05, 2009 6:32 am ] |
Post subject: | Re: Confusing Excel auto replace |
Hmm, got the spreadsheet and it works fine on my machine! ![]() I checked the conditional formatting, but it didn't show anything. It looks like it is either his profile or something on his machine! ![]() |
Author: | Fogmeister [ Wed Aug 05, 2009 6:53 am ] |
Post subject: | Re: Confusing Excel auto replace |
It could be auto correct options but that would work on all cells/columns. Is there any VBA attached to the workbook? |
Author: | big_D [ Wed Aug 05, 2009 8:37 am ] | |||||||||
Post subject: | Re: Confusing Excel auto replace | |||||||||
First thought was autocorrect, it isn't that, and there are no macros... ![]() |
Author: | AlunD [ Wed Aug 05, 2009 5:29 pm ] | |||||||||
Post subject: | Re: Confusing Excel auto replace | |||||||||
Is it just that spreadsheet or any spreadsheet? ![]() |
Author: | big_D [ Wed Aug 05, 2009 6:22 pm ] |
Post subject: | Re: Confusing Excel auto replace |
Just that spreadsheet, as far as I can see. He is back in the office tomorrow, so I'll see if I can see anything then. |
Author: | AlunD [ Thu Aug 06, 2009 6:25 am ] |
Post subject: | Re: Confusing Excel auto replace |
if its all spreadsheets he creates send him a blank you created if that is ok then its his master template that is holding the cause of it. so just save your blank as his normal.xlt ( I think thats what its called ). |
Page 1 of 1 | All times are UTC |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |