Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook only malfunctions on a single PC
I have an interesting problem. I have a workbook that I share between 100 or more people. The workbook does some simple calculations and formatting (like zip codes and total price). The work book functions an all computers except one. On that PC the work book will not format the zip codes or quantity fields correctly. (if you enter 2000 it will change to 2.000) If I copy that work book to another computer it works just fine. So I have isolated the problem to this one PC that is running office 2000 and has all the latest patches and updates. Any suggestions? -- Crypto ------------------------------------------------------------------------ Crypto's Profile: http://www.excelforum.com/member.php...o&userid=30330 View this thread: http://www.excelforum.com/showthread...hreadid=499947 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook only malfunctions on a single PC
Try checking the "Regional and Language" settings in the Control Panel on
that computer. "Crypto" wrote: I have an interesting problem. I have a workbook that I share between 100 or more people. The workbook does some simple calculations and formatting (like zip codes and total price). The work book functions an all computers except one. On that PC the work book will not format the zip codes or quantity fields correctly. (if you enter 2000 it will change to 2.000) If I copy that work book to another computer it works just fine. So I have isolated the problem to this one PC that is running office 2000 and has all the latest patches and updates. Any suggestions? -- Crypto ------------------------------------------------------------------------ Crypto's Profile: http://www.excelforum.com/member.php...o&userid=30330 View this thread: http://www.excelforum.com/showthread...hreadid=499947 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook only malfunctions on a single PC
It is set to english, US dollor etc. Is there a spacific setting I should look for there? -- Crypto ------------------------------------------------------------------------ Crypto's Profile: http://www.excelforum.com/member.php...o&userid=30330 View this thread: http://www.excelforum.com/showthread...hreadid=499947 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook only malfunctions on a single PC
I'm gonna guess that it's a setting on that problem pc:
Tools|Options|Edit tab|Uncheck Fixed Decimal places Crypto wrote: I have an interesting problem. I have a workbook that I share between 100 or more people. The workbook does some simple calculations and formatting (like zip codes and total price). The work book functions an all computers except one. On that PC the work book will not format the zip codes or quantity fields correctly. (if you enter 2000 it will change to 2.000) If I copy that work book to another computer it works just fine. So I have isolated the problem to this one PC that is running office 2000 and has all the latest patches and updates. Any suggestions? -- Crypto ------------------------------------------------------------------------ Crypto's Profile: http://www.excelforum.com/member.php...o&userid=30330 View this thread: http://www.excelforum.com/showthread...hreadid=499947 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Auto updating a workbook with data from another workbook | Excel Discussion (Misc queries) | |||
Creating multiple workbooks from summary workbook | Excel Discussion (Misc queries) | |||
How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
is it possible to use F9 to manually calculate in a single sheet or single workbook? | Excel Discussion (Misc queries) |