Link on deleting excel formatting

http://excelribbon.tips.net/T012259_Deleting_Unwanted_Styles.html

Excerpt:

Removing user-defined styles is very easy, though, if you use a macro. The following macro will quickly delete the unwanted styles:

Sub StyleKill()      Dim styT As Style      Dim intRet As Integer        For Each styT In ActiveWorkbook.Styles          If Not styT.BuiltIn Then              intRet = MsgBox("Delete style '" & styT.Name & "'?", vbYesNo)              If intRet = vbYes Then styT.Delete          End If      Next styT  End Sub  

The macro needs just a little user input. Whenever the macro detects a user-defined style, you are asked if you want to delete it. Clicking on the Yes button causes the style to be removed from the workbook.

I also found this link, however, currently has my workbook locked up so we'll see.....

https://support.microsoft.com/en-us/kb/291321

Too many cell formats in excel

For that infuriating "too many cell formats" error, I've found that sometimes, though not always, if you save down to Excel 97-2003 it seems to fix it.  But it's hit or miss.  It can also destroy everything.

Another more involved process is as follows, however, is also with risk….

This can completely destroy your excel file by removing ALL formatting, formulas, EVERYTHING and leave you with just raw useless text so SAVE another copy!!!!!!

Go to:  http://support.microsoft.com/kb/213904

Under the "Resolution" section click on "Remove Styles Add-In"

***Note, excel should be open***

Click on "Downloads" tab

Download: "RemoveStyles.xlam for Excel 2007 and newer"

You will get a download notification, and should click "Open"

You should now see a new button on the excel Home tab

****Highly HIGHLY recommend saving another copy of your excel file before proceeding in case something goes haywire you can still go back to your original file*****

Click on the "Remove Styles" button, and hope for the best.

-------

You know you've downloaded and installed the Remove Styles add-in before but now the button isn't showing on the home tab.

Go to File > Options > Add-Ins > Manage: Excel Add-Ins and click Go…

You will see a list of Add-Ins and likely the Remove Extra Styles is "checked".  You will want to "uncheck" Remove Extra Styles" then click OK, then go back in using the above steps and "check" Remove Extra Styles and click OK.  This should cause the button to reappear on the Home tab.

-----------------------------

OTHER THINGS TO TRY

Below ideas are not "confirmed" fixes, but things I have tried in the past that have seemed to help resolve the error

-Remove unnecessary conditional formatting: Home tab > Conditional Formatting drop down > Clear Rules from Selected Cells (or you can Clear Rules from Entire Sheet)

-Remove unnecessary drop down lists from Data Validation:  Select applicable cells > Data tab >

Parse Characters from a Cell

(LEFT(B55,22))

01302.03.3001.000.1000 - OY3 LABOR SUNK COSTS

will pull:  01302.03.3001.000.1000

Insert Excel File Name into a Cell

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

source of information:  http://mrspreadsheets.com/1/post/2013/01/excel-function-tutorial-7-insert-the-current-file-name-into-a-cell-with-getcell.html

Ostensible Subcontractor Affiliation links

http://smallgovcon.com/tag/ostensible-subcontractor-affiliation/

http://www.acq.osd.mil/osbp/councils/marc/resources/201111-small-business-teaming.pdf

http://www.cbh.com/teaming-agreements-and-the-ostensible-contractor-rule/

http://www.ecfr.gov/cgi-bin/text-idx?c=ecfr&tpl=/ecfrbrowse/Title13/13cfr121_main_02.tpl

http://www.ncmahq.org/docs/default-source/default-document-library/articles/cm0911---14-22

Kudos - 12 July 2014

Steve Baird regarding major proposal effort - Amy, thanks... The way you built your spreadsheet really assisted us in running all the different options in a very time sensitive environment ....it was a pleasure.

Excel formula

Old Salary X % Reduction = New Salary

When you only know the new salary and % reduction that was used, the formula to derive the old salary is:

<New Salary> / ( 1 - <Percent Reduction>)