Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wont keep changes
I am working on an excel spreadsheet shared by four people. We all have the
ability to go in, make changes, and save it. We have been working on it for months and have had no issues until recently. We have been highlighting rows different colors then scrolling down the page, when we return to our previous spot the highlights are gone. We also noticed different colors that we are not using popping up on the spreadsheet in random places with no rhyme or reason. If we enter data into a cell it will save, but the color of the cell won't. Our spreadsheet is over 40,000 rows and we use the colors to track what progress has been made, it also makes the spreadsheet more user friendly. Any ideas on what might be causing this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wont keep changes
Do you have VBA code behind the workbook?
We do something similar to what you are doing and our workbooks are much larger than 40K rows. We don't experience any of the problems you do. We are currently on Excel 2007, but we did the same thing (less rows of course) in Excel 2003 without the problems you describe. If you have some code behind your workbooks, it could possibly be the culprit. I'm guessing that you probably do have some code since you posted in the programming newsgroup. If so, please share some of the code and someone and/or I will look at it. Good luck! "PauleyG" wrote in message ... I am working on an excel spreadsheet shared by four people. We all have the ability to go in, make changes, and save it. We have been working on it for months and have had no issues until recently. We have been highlighting rows different colors then scrolling down the page, when we return to our previous spot the highlights are gone. We also noticed different colors that we are not using popping up on the spreadsheet in random places with no rhyme or reason. If we enter data into a cell it will save, but the color of the cell won't. Our spreadsheet is over 40,000 rows and we use the colors to track what progress has been made, it also makes the spreadsheet more user friendly. Any ideas on what might be causing this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wont Sum | Excel Worksheet Functions | |||
Date format from excel to CVS file wont. Change in CVS wont stay. | Excel Worksheet Functions | |||
Macro wont run! | Excel Discussion (Misc queries) | |||
wont calculate | Excel Discussion (Misc queries) | |||
Excel is there but it wont pop up | Excel Discussion (Misc queries) |