+ Reply to Thread
Results 1 to 1 of 1

Issue of Filter to a column having a formula & ability to insert row with formula

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2016 / Office: 365

    Issue of Filter to a column having a formula & ability to insert row with formula

    Hi Experts,

    I am in need of help with the following, I have attached a sample excel sheet.

    1. I have a protected excel sheet shared over SharePoint. I have a column with dragged columns to 2000 rows.

    Insert issue:
    When the users are inserting the row, they are missing the formula and also are not able to insert rows copied with existing rows (as excel is password protected)
    Please may I know the options I have, I do VBA which copies formula in the inserted rows but the excel tracker is .xlsx not .xlsm
    Is this something we can do on using SharePoint features?

    2. I have attached the sample excel, when I filter on the excel with formulas dragged to Nth row, the filter on any column is hiding all the rows with formula, Is there a way you can help me advise how to avoid this.
    The problem is users are filtering and using the rows beyond the formula as formula rows are hidden. :-( Now I am planning to lock all the cells below the formula but users have to filter to see the previous data. Any suggestions or solution is appreciated.

    Environment: Excel over Sharepoint & password protected

    Your help is appreciated.
    Attached Files Attached Files
    Last edited by protocoder; 05-05-2021 at 09:32 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Issue With Formula Not Automatically Adding Itself After "INSERT" or row or column
    By datacentralized in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-19-2019, 02:54 PM
  2. Replies: 1
    Last Post: 08-17-2019, 01:11 PM
  3. Formula Filter Issue
    By wacko1979 in forum Excel General
    Replies: 5
    Last Post: 11-07-2018, 08:37 AM
  4. [SOLVED] formula for a sum difference column and ability to add new rows without breaking formula?
    By jitterbug888 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2017, 08:01 AM
  5. Replies: 2
    Last Post: 08-15-2015, 04:25 PM
  6. VBA insert a row issue with formula
    By r0ot5 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-11-2013, 07:28 AM
  7. Filter Formula Issue
    By arvin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-07-2009, 04:37 PM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1