ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   could not save all data and formatting you recently added (https://www.excelbanter.com/excel-discussion-misc-queries/209062-could-not-save-all-data-formatting-you-recently-added.html)

Patricia D

could not save all data and formatting you recently added
 
Is there any way round this message? I have tried switching off error
notification and automatic calculation, but to no effect.

Sheet has a large number of cells with data validation (2262) and a large
number of cells with conditional formatting (9048).

The workbook is less than 600 KB in size, only 2 sheets, 2nd sheet has very
little data on it.

Workbook is saved with some of the data validation removed.
--
Patricia D


All times are GMT +1. The time now is 09:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com