Daisygirl0144
New Member
Hello,
I am having a big problem. I have searched this forum and the internet and it appears that this is an Excel bug that has not been fixed, but there has to be a solution or work around to this because it is extremely time consuming to correct.
I have a workbook that has about 100 worksheets for our Personnel Projections. Each worksheet has the same table(s) in it with a total table as well (the number of tables depends on the number of employees in that group). There is also 2 Variable sheets that are used to pull data from. The problem is that sometimes (completely random) when I open the workbook, all cells that are formatted to General (I think....Accounting, $, % & Cutom don't seem to change) change to the Date format. This means that I have to select each cell that is formatted incorrectly and change it to the correct format. I have made a macro so I only need to hit control x to do this, but it is still incredibly time consuming to go through the entire workbook and correct this. The workbook that this is currently occuring on is brand new as we had this problem witht the old one and thought that maybe since it was intially created with 2003 version the problem was there, but I just encountered the same error with the brand new workbook I just created in Excel 2010. I am entering all the information into the new workbook, not copying and pasting it. I am uploading one sheet as an example.
Any assistance or advice would be greatly appreciated!!
Frustrated,
Daisygirl
I am having a big problem. I have searched this forum and the internet and it appears that this is an Excel bug that has not been fixed, but there has to be a solution or work around to this because it is extremely time consuming to correct.
I have a workbook that has about 100 worksheets for our Personnel Projections. Each worksheet has the same table(s) in it with a total table as well (the number of tables depends on the number of employees in that group). There is also 2 Variable sheets that are used to pull data from. The problem is that sometimes (completely random) when I open the workbook, all cells that are formatted to General (I think....Accounting, $, % & Cutom don't seem to change) change to the Date format. This means that I have to select each cell that is formatted incorrectly and change it to the correct format. I have made a macro so I only need to hit control x to do this, but it is still incredibly time consuming to go through the entire workbook and correct this. The workbook that this is currently occuring on is brand new as we had this problem witht the old one and thought that maybe since it was intially created with 2003 version the problem was there, but I just encountered the same error with the brand new workbook I just created in Excel 2010. I am entering all the information into the new workbook, not copying and pasting it. I am uploading one sheet as an example.
Any assistance or advice would be greatly appreciated!!
Frustrated,
Daisygirl
