Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do some cells show up as XXXX's on a shared drive
I am building spreadsheets to be viewed on another computer on our shared
drive. However, sometimes cells with the date in them show up as XXXXXX's. Similarly, some cell with formulas to do sums show up as XXXXX's also. Is there a difference in the settings on the two computers? If so, how do I fix this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do some cells show up as XXXX's on a shared drive
I think you mean ######
The columns are too narrow so widen them. The reason it occurs on some setups and not others is probably due to resolution and/or printer drivers being different. You have to get everyone standardized on both accounts. Gord Dibben MS Excel MVP On Wed, 10 Sep 2008 18:02:01 -0700, Thomas Bren <Thomas wrote: I am building spreadsheets to be viewed on another computer on our shared drive. However, sometimes cells with the date in them show up as XXXXXX's. Similarly, some cell with formulas to do sums show up as XXXXX's also. Is there a difference in the settings on the two computers? If so, how do I fix this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do some cells show up as XXXX's on a shared drive
hi
not sure but i think you may be seeing ##### instead of XXXXX. this may not be a settings thing between the 2 pc's but more a column width thing. try adjusting the column width on the pc's that's giving you problems. Regards FSt1 "Thomas Bren" wrote: I am building spreadsheets to be viewed on another computer on our shared drive. However, sometimes cells with the date in them show up as XXXXXX's. Similarly, some cell with formulas to do sums show up as XXXXX's also. Is there a difference in the settings on the two computers? If so, how do I fix this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving shared spreadsheets on a shared drive. | Excel Discussion (Misc queries) | |||
shared spreadsheet on a shared drive | Excel Discussion (Misc queries) | |||
Printing viewing a shared workbook on a shared drive | Excel Discussion (Misc queries) | |||
Excel on shared drive | Excel Discussion (Misc queries) | |||
How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions |