Read-only?

[blizzard0c]

I have created and finished my workbook successfuly. I have one minor issue and one major. The minor issue has been addressed in a different thread.

The major issue I am having has to do with not being able to use it when a copy of the workbook is opened on my cell phone/pda.

I have read thru many of the topics on protection/unprotecting worksheets/cells and have not seen this specific issue arise elsewhere.

The steps I have taken for protecting the worksheet are:

1.Password protected every block as a whole via select-all. - Locked and Hidden checked -

2. Manually unlocked all row/column/cells necessary for variable input.

3. Of the 4 sheets in the workbook, two are protected (via "protect sheet") allowing users to "select locked cells" and "select unlocked cells" only.
- The other two sheets allow users to only "select unlocked cells"

The result works perfectly when using the workbook on the computer it was writen on.

When I put a copy of the workbook on my mobile device (cell phone/pda) it sends me a message indicating a "read-only" file and I am unable to modify anything. Including the cells I have left unprotected.

I have checked the properties of the file on the computer and the attributes "read-only" and "hidden" are not selected. Under Advanced Attributes the boxes "File is ready for archiving" and "For fast searching, allow Indexing Service to index this file" are the only two boxes checked off.
I have attempted to uncheck these boxes with no change.

When the file has been copied to the storage card on my mobile device, the "read-only" attribute is not checked. "Archive" is checked and also grayed out making it unable to change.

The only thing I can come up with is that I am doing something wrong while protecting the sheets and need to allow something that I am not. Or maybe I need to change a setting within Excel before saving it to stop this from happening.

Please help me solve this issue or tell me if it is not possible.

I am using Office 2007 Pro on an XP Platform

[blizzard0c]

well im sure this has to do with the fact that im dealing with excel mobile.

I'm gonna search around on microsofts website and see if i can find anything on there about saving the workbook to be used on mobile.

I cant imagine they would make excel for pda/cell phones an excel worksheet reader only but wouldnt discount the possability. Maybe that would be useful to some but i would just assume use a $20 tumbstick vs. a $450 cell phone. Or lug around the laptop if really necessary.

I'm sure many of you enjoy researching this stuff so if you do and find something before i do please post it here.

[davesexcel]

well im sure this has to do with the fact that im dealing with excel mobile.

I'm gonna search around on microsofts website and see if i can find anything on there about saving the workbook to be used on mobile.

I cant imagine they would make excel for pda/cell phones an excel worksheet reader only but wouldnt discount the possability. Maybe that would be useful to some but i would just assume use a $20 tumbstick vs. a $450 cell phone. Or lug around the laptop if really necessary.

I'm sure many of you enjoy researching this stuff so if you do and find something before i do please post it here.

You question is very long, something I spotted were that you did not have any unlocked cells, you just protected the sheet, unless

manually unprotect cells

is in fact unlocking them, is this the case??

[blizzard0c]

yes sir. Oh I see where the confusion is. I said unprotected while in fact cell protection is refered to as locked or unlocked and hidden or not hidden. Worksheet refers to unprotect and protect.

You are correct, I did mean unlock the cells necessary for variable input.

I did not unhide them, only unlocked them. There is no code in any of those unlocked cells either.

Thanks, I have made that correction.

[davesexcel]

yes sir. Oh I see where the confusion is. I said unprotected while in fact cell protection is refered to as locked or unlocked and hidden or not hidden. Worksheet refers to unprotect and protect.

You are correct, I did mean unlock the cells necessary for variable input.

I did not unhide them, only unlocked them. There is no code in any of those unlocked cells either.

Thanks, I have made that correction.

This is unfamiliar territory for me, I assume the new technology is able to process data for portables rather than just reading them...

[blizzard0c]

I am posting this link just in case anyone wasnt sure what I'm talking about, the mobile thing.

http://www.microsoft.com/windowsmobi...el-mobile.mspx


As expected, I have found nothing of use in resolving this issue on the MS website thus far. I'm sure there are still pleanty of people making buco bucks with the knowledge they have regarding office mobile. I figued free help on the web may be scarce. Perhaps I should download Excel for Dummies.

Well I'll just keep digging in the mean time. Start from A and work my way to Z and hopefuly figure it out.

If you find anything please post it.