There is a maximum number of cells allowed in table named ranges (MaximumCellCount). This limitation is there to improve the performance of your application during design-time. The total number of cells is limited to 1,000 on Trial accounts and 5,000 on Public Cloud accounts if meta-data formatting is enabled to prevent any performance issues. These numbers also include the headers. For example, if you have a Table Named Range with 30 columns and 1,000 rows, it will not be available in the User Interface Designer, because the total number of cells exceeds the 5,000 limit. There is no cell limit if meta-data formatting is not enabled. This is a configurable option in server and private cloud licenses. When logged in as the “systemadmin” user, go to Tools > Designer > Configuration Settings, and press the Edit button next to the MaximumCellCount field to change this value.
-
- Can a web user update formulas in my workbook
- Can I brand SpreadsheetWEB Control Panel?
- Can I have a custom URL for my SpreadsheetWEB Site?
- Can I receive data submitted to my web application via email?
- Can I store the data submitted to my web-page?
- Do you support Microsoft Excel's built-in form controls?
- Does SpreadsheetWEB convert my spreadsheet into a proprietary format?
- Does SpreadsheetWEB have support for mobile devices?
- Does SpreadsheetWEB support all types of cell formats in Microsoft Excel?
- Does SpreadsheetWEB support Microsoft Excel macros?
- How can I reset my password?
- How can I update a web application I created?
- Is SpreadsheetWEB an online spreadsheet application like Google Docs?
- Which Versions of Microsoft Excel are supported?
- Which web browsers do you support?
- Why is my SpreadsheetWEB application loading slower than Excel?
- Which Microsoft Excel functions are supported?
- How can I update the underlying workbook of my web application?
- Show all articles ( 3 ) Collapse Articles
-
- Can I embed a converted web-page into my website?
- Combobox shows default or empty value after calculation.
- I am getting the error "Internet connection could not be established! Please check your internet connection and try again.
- I am using an older version of SpreadsheetWEB on my server. Where can I download a matching version of the Excel Addin?
- I converted and uploaded my workbook, but I am getting some unwanted lines
- I converted my spreadsheet into a web application. I need to make some changes in my workbook. Do I have to go through the whole conversion process again?
- I have a very complex Microsoft Excel file. It includes some features that are not supported by SpreadsheetWEB. Can you help me to convert?
- I uploaded my spreadsheet to the server but the web application doesn't work. What should I do?
- Sometimes it takes too long to load my application. Why?
- Why am i getting "Inserting worksheet is disabled" message?
- Why do I lose my data when I change tabs in a SpreadsheetWEB application placed within an iFrame?
- Why does my SpreadsheetWEB application timeout?
- A named range I have in the workbook is not showing up on the User Interface Designer
- How can I remove double scroll bars in applications within iframes?
-
- Can I install SpreadsheetWEB Addin on a Mac computer?
- Can I run SpreadsheetWEB on my server? What are the requirements?
- Do I need Microsoft Excel to create web applications with SpreadsheetWEB?
- Do I need Microsoft Windows to create web applications with SpreadsheetWEB?
- Do the visitors of the web application I have created with SpreadsheetWEB need Microsoft Excel or SpreadsheetWEB?
- I installed SpreadsheetWEB Addin but cannot see it on the menu.
- Is there a direct download link for SpreadsheetWEB Addin?
- How can I uninstall the SpreadsheetWEB Excel add-in?
- Can I Install SpreadsheetWeb on Azure?
- Can I Install SpreadsheetWeb on AWS?
-
- Do you have free evaluations?
- How can I cancel my SpreadsheetWEB subscription?
- How can I change my payment method or credit card information?
- How can I return my software?
- How is SpreadsheetWEB licensed?
- What happens to my web applications, if I cancel my account?
- What is the difference between licensing models?
- What are your business hours and how fast do you answer support inquiries?
-
- Does SpreadsheetWEB Support Transparent Data Encryption (TDE)?
- How Can I Change Password Rules?
- How can I change session timeouts on my SpreadsheetWEB server?
- How can I find the error log files? Where are they located?
- How Can I Renew or Update My Licensing Key?
- How can I replace SpreadsheetWEB logo in the Control Panel with my own?
- I am getting the error "Server is busy" when trying to upload a new application
- How can I update or migrate the software? Do you offer help with these tasks?