| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving a worksheet
Hi When I save, a warning appears that data and formatting recently added can not be saved. How can this be overcome ? Thanks in advance -- JONESAROB ------------------------------------------------------------------------ JONESAROB's Profile: http://www.excelforum.com/member.php...o&userid=37063 View this thread: http://www.excelforum.com/showthread...hreadid=567816 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Saving a worksheet
"JONESAROB" wrote
in message ... Hi When I save, a warning appears that data and formatting recently added can not be saved. How can this be overcome ? Thanks in advance Are you opening files in Read-Only mode? (It'll tell you on the top of the window.......) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Saving a worksheet
I think I have found out why, it is because you can not have more than 2500 conditional formatting per work sheet. I had about 6500, so therefore I have broken it down into three sheets, and now it saves ! Thank you for your reply, if you know different give us a shout. -- JONESAROB ------------------------------------------------------------------------ JONESAROB's Profile: http://www.excelforum.com/member.php...o&userid=37063 View this thread: http://www.excelforum.com/showthread...hreadid=567816 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems saving a worksheet with links | Excel Discussion (Misc queries) | |||
| One worksheet to calulate different items simultaneously | Excel Worksheet Functions | |||
| Saving into 1 workbook as a different worksheet | Excel Worksheet Functions | |||
| Keeping Worksheet tab colors when saving as web page | Excel Discussion (Misc queries) | |||
| Saving a copy of a worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
