| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit on number of comments in a worksheet
Good day!
I've written a macro that validates the cell values in a worksheet, and writes the error messages as comments in each cell. The problem I'm having is that if there are too many rows (at least 2000) and too many errors, writing all those comments make Excel slow and the memory usage very high (at least 200MB), and causes "Excel cannot complete this task with available resources...". Why is this so? Is there any workaround for this? Thank you very much. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Limit on number of comments in a worksheet
Consider using an audit sheet. As your macro validates values on your data
sheet, have it record the row/column id of error records an the audit sheet. It can even change the background color of cells on the data sheet to help visually see where the problems are. -- Gary''s Student - gsnu200789 "dyowee" wrote: Good day! I've written a macro that validates the cell values in a worksheet, and writes the error messages as comments in each cell. The problem I'm having is that if there are too many rows (at least 2000) and too many errors, writing all those comments make Excel slow and the memory usage very high (at least 200MB), and causes "Excel cannot complete this task with available resources...". Why is this so? Is there any workaround for this? Thank you very much. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Limit on number of comments in a worksheet
What is an audit sheet? =)
"Gary''s Student" wrote: Consider using an audit sheet. As your macro validates values on your data sheet, have it record the row/column id of error records an the audit sheet. It can even change the background color of cells on the data sheet to help visually see where the problems are. -- Gary''s Student - gsnu200789 "dyowee" wrote: Good day! I've written a macro that validates the cell values in a worksheet, and writes the error messages as comments in each cell. The problem I'm having is that if there are too many rows (at least 2000) and too many errors, writing all those comments make Excel slow and the memory usage very high (at least 200MB), and causes "Excel cannot complete this task with available resources...". Why is this so? Is there any workaround for this? Thank you very much. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a limit to the number of formulas in an Excel worksheet? | Excel Worksheet Functions | |||
| How to limit number of rows and column in worksheet? | Excel Discussion (Misc queries) | |||
| is there a limit to the number of rows a worksheet can have? | Excel Discussion (Misc queries) | |||
| How do I limit the number of rows displayed on a worksheet? | Excel Discussion (Misc queries) | |||
| How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions | |||
Linear Mode
