General

Alternatives to MS Query for Pivot Tables & Cubes
I am using Excel 2003. I would like to know if there is an add-in or other (preferably free) tool out there that I could use to create OLAP cubes for Excel pivot tables that would have better functionality than MS Query. I find MS Query very difficult to use and almost impossible for creating calculated fields ... 14 Jan 2010 13:34

in excel, what is the formula that will add a number each month
Excel 2007 XP O/S I am working with a work schedule, Each month I get one sick day so I would like the first of each month 10 (hours) be added to a cell I have set up with my sick leave. I would also like this to top out (stop) at 720. I would also like for the same day each year for one cell to be automatica... 14 Jan 2010 12:26

Fitting to scale?
I have inconsistencies when I select fit to scale, sometimes I get large white spaces (about 1.5 - 2 inches on either side) and the page looks really narrow. How can i fix this and get a more consistent look to all the workbooks. ... 14 Jan 2010 12:26

Making macros unvisible
I have a database where you type a part # and (by using macros) it brings up the different storage locations for that part. How do I make that macro invisible or password protected? I can use Security on high but there are other co-workers who know that. ... 15 Jan 2010 14:58

Pivot Table date format
The "data" worksheet has the correct date format -mm/dd/yy. There is no time stamp When in the pivot table worksheet the date is showing up as :00, :01, :02...... What appears to be a truncated time format. I have tried to set the date format in both the data worksheet and the pivot table worksheet with n... 14 Jan 2010 10:10

Linked Cells
I have linked two worksheets from different workbooks and I noticed that when I enter text into a cell, only a portion of the text appears in the worksheet linked to it. Have I missed a critical setting or is there a small limit to the amount of text I can use? -- JimR ... 14 Jan 2010 11:19

Print Excel files from a BAT file.
I would like to print to a network printer a bunch of Excel files using a BAT file. The network printer drivers are installed in Windows XP. I read the Excel parameters but none are for sending a print job to a printer. Can someone provide a BAT Start commnad line for me? -- Victor Manske Computer Network & S... 14 Jan 2010 10:10

Notify of Replies
I do not get notifications when someone replies to my postings. Are you ever going to fix this? Please advise. Send to my email directly as I get no notifications even though I check the "notify me of replies" checkbox. Thanks. ---------------- This post is a suggestion for Microsoft, and Microsoft resp... 16 Jan 2010 00:55

formula
I am trying to create an IF formula. Example wherever if i will type in excel sheet same name "X"1000 cells.I want show one cell 1000: ... 14 Jan 2010 09:03

where can I find a template for church inventions
I am looking for templates for different church events, letters, memos ex. ... 14 Jan 2010 09:03