Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello, I work in department that we use Excel to log anything that is going
on or what we turn in for our university. We have Office 2007 on all our computers. But when one person brings up the excel document. Anything that was typed by the last person used it. Its coming up different, good example the time we typed in log entry of 3:30. It would have some weird number like 0.094643782. Two of our columns we keep things centered and bold. But if you bring up the excel document one or two or more rows will have it right side and not bold. The column we type information in its left side and bold and its texted wrapped. Well, on some rows, its left side but its not bold and its not texted wrapped. Some times we fill in boxs with colors as important information. So next operator will see it, well the colors are not there 3/4 of time. The weird thing about this is if affects some of it. But you go to fix it, and stays the what should be. I tried updating making sure all computers that we use excel and all are updated and still happens. Updated the computers and still same result. My question is there an patch out there I can download from Microsoft that would fix this. Or is there something wrong. Pretty much make it simple just in case I lost someone what I am saying. If I would save my excel document and close it. And next person thats opens it, will see it different but maybe little different or alot different. The text is same but what we have setup in boxes and columns changes by itself. Thank you for your time reading this and hope someone has solution to this I can put on these computer to end this. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I really don't have a definitive answer for you. You might start by visiting
this page http://office.microsoft.com/en-us/excel/default.aspx and check for updates (upper right corner). It sounds like the file is losing formatting in going from user to user. For example, I'm betting that the strange appearance of a value like 0.09#### where you previously had a time entry is because the cell has gone from Time format to simply General format. You might be able, with a little knowledgable assistance, to record and modify one or more macros combined with the Workbook_Open() event to set the formatting in the various cells/rows/columns upon opening the workbook. "Chris G." wrote: Hello, I work in department that we use Excel to log anything that is going on or what we turn in for our university. We have Office 2007 on all our computers. But when one person brings up the excel document. Anything that was typed by the last person used it. Its coming up different, good example the time we typed in log entry of 3:30. It would have some weird number like 0.094643782. Two of our columns we keep things centered and bold. But if you bring up the excel document one or two or more rows will have it right side and not bold. The column we type information in its left side and bold and its texted wrapped. Well, on some rows, its left side but its not bold and its not texted wrapped. Some times we fill in boxs with colors as important information. So next operator will see it, well the colors are not there 3/4 of time. The weird thing about this is if affects some of it. But you go to fix it, and stays the what should be. I tried updating making sure all computers that we use excel and all are updated and still happens. Updated the computers and still same result. My question is there an patch out there I can download from Microsoft that would fix this. Or is there something wrong. Pretty much make it simple just in case I lost someone what I am saying. If I would save my excel document and close it. And next person thats opens it, will see it different but maybe little different or alot different. The text is same but what we have setup in boxes and columns changes by itself. Thank you for your time reading this and hope someone has solution to this I can put on these computer to end this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
opening same excel file at different computers in real time | Excel Discussion (Misc queries) | |||
opening same file on 2 computers simultaneously with excel 2007 | Excel Discussion (Misc queries) | |||
excel compile error. Only some computers? | Excel Discussion (Misc queries) | |||
excel compile error. Only some computers? | Excel Discussion (Misc queries) | |||
How do I transfer macros in excel between two computers? | Excel Discussion (Misc queries) |