Using Data List & Locking Select Cells affects list functionality

marge

New Member
Joined
Jan 19, 2010
Messages
9
Hello, I designed an employee expense report form in Excel 2003 using the list function. The form looks like a table, with 6 columns and 20 rows, and the user lists expenses in the last 3 columns. In the 20th row of the table/list, there’s an asterisk/insert row. This is handy if the user needs to add more than 20 line items.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p> </o:p>
Underneath the list, I have Sum formulas for the last 3 columns i.e. =SUM(D1:D20).
<o:p> </o:p>
The problem is that I want to lock these formula cells, but seems to affects the list’s functionality. The asterisk on the insert row disappears and the list can no longer grow. If I unprotect the formula cells, the insert row reappears. How can I have both the locked cells and the list’s insert row?

Thank you! :rolleyes:
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

marge

New Member
Joined
Jan 19, 2010
Messages
9
VoG, thanks for answering. Unfortunately, I just tried this and it did not seem to work. :(
 

Gonzo346

New Member
Joined
Aug 31, 2009
Messages
11
VoG, thanks for answering. Unfortunately, I just tried this and it did not seem to work. :(
Hi Marge,
I bumped into the same problem and can´t find my way around it. Did you get fixed finally?
 

Watch MrExcel Video

Forum statistics

Threads
1,095,394
Messages
5,444,218
Members
405,274
Latest member
go2nivas

This Week's Hot Topics

Top