Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Security??
I make a Time sheet templae with all the formulas and I use at work, It dose everything I want, buy yesterday at work one of the lads asked if they could have a copy for there laptop, no problem except even though I protected the worksheets when I put it on his laptop all the dates came out as ****** and all the cells were open. I found out that his laptops language was set at United States which caused the ****** on the date cells but I can't understand why the cells are open. When I checked the protection its still protected. Im not sure what version of excel he has but could this make a differance, the timesheet I put together was with excel 2003. -- Chris Watson ------------------------------------------------------------------------ Chris Watson's Profile: http://www.excelforum.com/member.php...fo&userid=4700 View this thread: http://www.excelforum.com/showthread...hreadid=518598 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Security??
I've never seen cells change from locked to unlocked or vice versa.
But if you really saw #######'s (not ******'s), then it could be because you used your system's default date format to show the date. When your co-worker opened the file, the date was displayed as his default format. So if you use dd/mm/yy and he uses mm/dd/yyyy, then the column won't be wide enough to see it all--so excel shows the ######. The dates will be the same--it's just a display problem. You could widen the column, use a smaller font or format|cells|alignment tab|shrink to fit?? or use a non-standard date format--so that the system default isn't used. (You may have to unprotect the worksheet to change some of this.) Chris Watson wrote: I make a Time sheet templae with all the formulas and I use at work, It dose everything I want, buy yesterday at work one of the lads asked if they could have a copy for there laptop, no problem except even though I protected the worksheets when I put it on his laptop all the dates came out as ****** and all the cells were open. I found out that his laptops language was set at United States which caused the ****** on the date cells but I can't understand why the cells are open. When I checked the protection its still protected. Im not sure what version of excel he has but could this make a differance, the timesheet I put together was with excel 2003. -- Chris Watson ------------------------------------------------------------------------ Chris Watson's Profile: http://www.excelforum.com/member.php...fo&userid=4700 View this thread: http://www.excelforum.com/showthread...hreadid=518598 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
Pivot Table Security in Excel | Excel Discussion (Misc queries) |