A little help needed, I have a Macro automatically creating pivot tables and charts, this is all working fine but I am getting (blank) in my pivot table becuase my range is all the way to 65536.
I am having difficulty opening a EXCEL 2007 in Delphi 7 It works for Office 2003 and below but the wonderful people at microsoft have sent an update or something and the delphi app fell over just earl
My task is to get text to print and display though it is longer than the 409 point row show.The sheet I\'m working on is a Destination sheet from a Source sheet that can change often, but generally on
I have created a xlt excel template which works fine in Excel 2007 under compatibility mode and shows no errors on compatibility check.The template runs a number of Macros which creates pivot tables a
I have this: ActiveCell.Formula = \"=COUNTIFS(G$4:G$\" & (i - 1) & _ \", Sheets(ActiveSheet.Name).Cells(3, 25).Value ,F$4:F$\" & (i - 1) & _
I have a开发者_开发问答n excel file that has conditional formating set up to put a check or an x in a cell. How can I create an if statement that will detect which is in there without using the origin
I would like to create a excel Add in which creates some additional toolbars and Menu buttons. But I want this addin to load only when a specific workbook is opened. I dont want to load the Addin if a
Is this something I need to write or something already exists. Google is pulli开发者_运维知识库ng up a bunch of junk.At the risk of totally missing the point, did you already try File -> Save As, and
I have not got much experience in Excel.Any help appreciated. I开发者_如何学Python have 10-11 csv files , that can be opened in excel. I have duplicate records in all the files.I need to count the uni
So, I need to find an Excel 2003 substitute for =SUMIFS, which is only 2007+ (apparently). The formula is used to generate this summary data table, from a list of revenue, where each revenue line ha
加载中,请稍侯......