Hi,
I am aware that I can't use Custom View once I insert Excel Table in a workbook. But, If I convert that table back to range still I am not able to use Custom Views.
I tried closing all excel files and re-opening that specific files. This is really strange and seems to be bug.
Just wanted to confirm whether this is also limitation of Excel table that once you insert it in workbook you can never use Custom view in that workbook later.
Please also tell me if there are any other limitations to this.
I am aware that I can't use Custom View once I insert Excel Table in a workbook. But, If I convert that table back to range still I am not able to use Custom Views.
I tried closing all excel files and re-opening that specific files. This is really strange and seems to be bug.
Just wanted to confirm whether this is also limitation of Excel table that once you insert it in workbook you can never use Custom view in that workbook later.
Please also tell me if there are any other limitations to this.