Hi all
I have a datasheet that is refreshed with data When this happens the auto filter needs to be reapplied to remove blanks (this is so when the user sorts the data they just get the data they want)
To get round this so the user doesn't have to reapply the filter every time I created a macro which does and all works great.
However this workbook is to be viewd on Sharepoint 2013 (excel services) which can't handle macro workbooks.
In sharepoint you don't have the reapply button either/setting that reapplies auto filters. A dynamic range would not work as the sort would still be looking at a formula.
Any ideas would be great.
Thanks
I have a datasheet that is refreshed with data When this happens the auto filter needs to be reapplied to remove blanks (this is so when the user sorts the data they just get the data they want)
To get round this so the user doesn't have to reapply the filter every time I created a macro which does and all works great.
However this workbook is to be viewd on Sharepoint 2013 (excel services) which can't handle macro workbooks.
In sharepoint you don't have the reapply button either/setting that reapplies auto filters. A dynamic range would not work as the sort would still be looking at a formula.
Any ideas would be great.
Thanks