I'm an Excel newbie, and am a little baffled about controlling the visible size of a spreadsheet.
I've made up a spreadsheet with about 11 sheets, using approximately a range of A1 to I100, although each sheet varies.
I've hidden the extra millions of rows and columns (Excel 2010).
I've run the add-in XSFormatCleaner to clean up whatever.
I save the file and its fine, it behaves itself on my PC.
I share the spreadsheet with another user who opens it on his Android Phone. He has permission to edit it as required. In fact, this is a form of inventory control, so I want him to enter what he uses up.
But, on whatever apps he tries on his phone, the spreadsheet always seems to want to open up with all the rows and columns 'unhid'. When he saves it, and then updates it on dropbox, I can open it on my PC for a current version, but it opens with the rows and columns unhidden.
So, somewhere I've missed out on how to control the real size of a spreadsheet. I don't need a gazillion rows and columns, how do I load something that is not huge? The filesize is only 38k, so that is not an issue.
Another funny thing: I tried to protect the worksheet, except for one column which I make editable with a password. But when the other user opens the spreadsheet in QuickOffice or Officesuite, there is no protection at all, and he needs no password at all and can edit every cell.
On my stupid Windows Phone, I cannot do anything with the entire sheet if any of it is protected. I get the message it is protected, even though it should only be partially protected everywhere except one row.
Is this how all this bull crap is 'state of the art' at present or what is up?
-Frustrated.
Bookmarks