Inserting a Table

[leimst]

Hello,


I inserted a table in excel so that subsequent rows carry the formulas with them. However, when I password protect the sheet the table no longer behaves as a table and the little blue triangle in the last row and farthest to the right column no longer appears. Is it not possible to protect a table?


Thanks,


Leimst

 

[Luke M]

What all options are you enabling/disabling when you protect the sheet?

 

[leimst]

Select locked cells, Select unlocked cells, Sort, and Use AutoFilter.

 

[leimst]

Hello,


I've tried enabling all of the "Allow all users of this worksheet to:" options when protecting a sheet but it still disables the "table" when I protect the sheet. What I'm trying to do is set up a form of sorts where the table expands as users provide input. Otherwise, I don't know what other options I have than to copy the rows and formulas down to row 500 or whatever I estimate could be the maximum number of rows that any particular user might need to input. At least that way I could lock the sheet to keep users from overwriting the formulas.


Any thoughts?


Thanks!


Leimst

 

[Luke M]

Can you hide the columns that contain the forums? (and not protect the sheet)

 

[leimst]

Unfortunately not. I've been instructed to let the users see the results returned by the formula columns based on the user's input which drives the formula results. That way they are able to see that they do not need to fill out those columns. I am also dealing with a broad spectrum of Excel skill levels in that some of the users don't even realize that there are additional tabs that they can chose at the bottom of the spreadsheet while others have unhidden sheets and columns that I did not want them find or change.


Thanks,


Leimst

 

[SirJB7]

Hi, leimst!

A workaround for hiding formula columns and still displaying formula values is adding a new column (let's say G) for each column with formulas (B), in G2 type unquoted "=B2", and then hide column B.

Will this work?

Regards!