Search results

Hello Chandoo Community! First off... I am new to the OLAP Tools in excel so pardon my ignorance on this topic. Okay here is the situation, I have a OLAP cube that was created and now pulled into excel via pivotable/analysis services. Now I pulled a pivot table where in the rows I have names...

Yes Macro's are fine and Yes this is literally just for a print off to send to the customer.

Hello Everyone! Here is my situation... I have a "invoice" per say in a excel sheet that consists of 3 pivot tables stacked one above each other. I have to have them one after the other and not side by side due to it has to fit on one print sheet and look "professional". MY PROBLEM is, some...

I have recently being using the PowerPivot Add-on to excel in order to pull in more data and more effeciently analyze a large amount of data without bogging down my computer. My question is, I noramlly create excel files for other users, and normally I would write a macro that when "ran" ...

Okay.. So I may sound stupid here so sorry in advance if this is a dumb question. I have written the below code into my excel file. I had a similiar file where I had similar code and was able to save the file as a .xls and not a .xlsm (macro based). This file with this code is requiring me to...

I have a user that has Office 2003 installed on a Windows XP machine and is trying to open an Excel 2007 document that is password protected. When you click on Open a prompt will come up asking for a password. When you hit Cancel the message then tells you the converter failed. The workbook...

I have two tabs, one called "Names" tab that I have a list of names in column A, and the second "Template" I have a template. What I would like to do, is every month, go to the list of names and manually changed them to the desired names(roughly 20 of them). Then what i would like to do is have...