View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] randy.rower@gmail.com is offline
external usenet poster
 
Posts: 1
Default Created invoices in Excel - not working in Drive

I created several invoice templates in Excel using data validation drop down lists and vlookup to populate the type of service being provided and the rate. I used other cells to count the number of sessions. I also locked each of the cells that I don't want anyone to accidentally change or erase the formulas (the vlookups). When we placed them in Drive today for use, the drop down list is not visible (so it no longer works, I guess). The invoice is rendered useless.

Can you offer any help?