Please Share your Product Ideas with us!

All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.

Enable mass update of Excel file generated through Excel Integration

Excel files generated through Excel Integration are protected such that users are only able to update single cells.  We would like to have this protection modified to allow for mass updates (ie Find and Replace).  Lack of this ability negates the value of exporting the data and the user is just as well off working within DSP updating one record at a time.

 

Thanks

  • Guest
  • Feb 21 2018
  • Already exists
Stewardship Tier (SST) Framework / Framework
  • Mar 26, 2018

    Admin response

    Find and Replace are supported already in the Excel Integration.  The issue occurs if you try to replace a value that is found in the header columns that are locked to prevent modification.  If you highlight the entire data segment, excluding the column headings you will be able to perform a full find and replace.  Obviously this can cause issues with drop down lists, etc, so please verify the contents after running a replace.

  • Attach files
  • Guest commented
    March 26, 2018 13:20

    Thank you for the response. I have tried various types of selections. Full data set, partial data sets, full rows, etc. In every case, I have excluded the headers and in every case I am told the protection on the sheet prevents this type of change. I have provided a screen shot below. Can you please confirm that I should be able to perform this function and what I may be doing wrong?

    Best regards,

    Michael

    [cid:image002.png@01D3C4E3.B3DE58B0]

    Image 3.jpeg
    Image 2.png
    Image 1.jpeg
    ×

    Attachments Open full size

Related ideas