The ESP Add-in for Microsoft Excel has some known issues and limitations.
- Performance degrades when Max Rows is set to a large value, for example, several
thousand rows or more. The machine becomes very busy as it attempts to
process and complete the request.
- When Event Stream Processor stops or the connection is lost due to network
failure, the ESP Add-in for Microsoft Excel screen is not automatically
refreshed to reflect the current state of the query and connection. Refresh
the screen by selecting either the connection or the query to show the
current state of the selected object.
- You cannot use more than one worksheet containing ESP Add-in for Microsoft Excel
connection or subscription information within the same instance of
Excel.