I’ve created a financial spreadsheet for a colleague and try to Protect only the formula cells.
It works, but if the user enters a larger dollar amount the cells show ### and the user CANNOT adjust the width or height of the columns or rows.
I’ve tried everything I can think of to fix this…
Any suggestions?
Thanks
You cannot resize a protected cell; which implies that you cannot resize a column having at least a single protected cell. If your column consists of only unprotected cells, it may be resized (just tested with 5.4.4.2). Which allows you to (re)structure your spreadsheet to have whole unprotected column to get it resizable. Other than that, protecting is protecting, so you have to provide enough space in advance for possible amounts of data at the spreadsheet construction phase. You are the creator of some king of application, and ignoring possible input is bug of yours.