arifpunekar
New Member
- Joined
- May 2, 2014
- Messages
- 32
sir i am working windows 7 macro enabled workbook.
i have five sheets in workbook , in one sheet is 300 columns and 15000 rows ,and many formulas in workbook like if , hyperlinks ,sumif ,sum,data validations, duplicate value formula.
vb code for todays date reminder,multiple option in data validation cell , feez unfreeze columns.
and font is calibari and devkruti 050 two fonts in one worksheet .
when I insert delete or copy row or column error massage is come,
excel cannot do this task with available resources an choose less data or close other application. I have check task manager there is no other applications are running.
but in other worksheet of same workbook when I insert or delete row o column there is nothing workbook work regularly.
so sir please please tell me the solution as early as possible , thanks in advance.
i have five sheets in workbook , in one sheet is 300 columns and 15000 rows ,and many formulas in workbook like if , hyperlinks ,sumif ,sum,data validations, duplicate value formula.
vb code for todays date reminder,multiple option in data validation cell , feez unfreeze columns.
and font is calibari and devkruti 050 two fonts in one worksheet .
when I insert delete or copy row or column error massage is come,
excel cannot do this task with available resources an choose less data or close other application. I have check task manager there is no other applications are running.
but in other worksheet of same workbook when I insert or delete row o column there is nothing workbook work regularly.
so sir please please tell me the solution as early as possible , thanks in advance.