Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Public Sub UpdAllPivots() Dim shtThing As Worksheet Dim pvtThing As PivotTable For Each shtThing In Application.Sheets For Each pvtThing In shtThing.PivotTables pvtThing.ChangePivotCache ActiveWorkbook. _ PivotCaches.Create(SourceType:=xlDatabase, _ SourceData:="C:\Documents and Settings\shahryarm\Desktop\[Combined 09S 20090407v8.xlsm]Combined Grantee Main Data!R3C4:R50000C252", _ Version:=xlPivotTableVersion12) Next Next End Sub
|Excel style change characters to English characters.||2||18|
|How to parse out individual records from values in a column in Excel||1||27|
|How to always round a decimal up||5||20|
|I need macro to insert an character||8||19|