ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel could not save all the data and formatting you recently added (https://www.excelbanter.com/excel-worksheet-functions/152585-re-excel-could-not-save-all-data-formatting-you-recently-added.html)

Amedee Van Gasse

Excel could not save all the data and formatting you recently added
 
I think I found it.
I got a clue from this post:
http://groups.google.be/group/micros...d50703f0a298f7

I copied a cell in row 2, and pasted data validation in that column
for rows 2 - 13k-something. That makes it one continuous range with
validation. I repeated for 3 other columns with validation, who happen
to be next to each other.
After that I was able to save without any error.

I would like to say thank you to Debra Dalgleish.

--
Amedee



All times are GMT +1. The time now is 07:00 PM.

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