Search results

WHOA, its been LOOOOONG time... So I'm working with several numbers that are stored as 5,222 in the cell, but the number represents an assume 'millions'. meaning that if the cell shows 5,550 it represents 5,550,000. I'm trying to create a chart based on this but the chart will obviously plot at...

I wouldn't be surprised if the answer isn't right under my nose... I have a PivotTable (the end... lol.. just kidding). the PivotTbl has a list of various departments and in the 'Values' field/box it is adding the total number of Pages for each Department. What I'm trying to do is also...

ok, feeling a little 'dumb' by not being able to figure this out... i have a chart that looks at the past 6 months of data. i changed the colors used in the chart but now when i updated/refresh the chart and get a new month, the colors change!! i created/saved the 'chart as a template' and i...

First off, I am very new; a 'newborn/infant' if you must, when it comes to VBA. I can accomplish the simplest of things to existing code, but do not know enough to write my own lines. so your help is greatly appreciated!! so heres what I'm doing/needing: i have a report that is ran each...

So I have several PivotTables (and about to make several more) that are looking at data from the 'past 6 months'. right now, i have the Date in my column headings and manually check and uncheck the correct months. meaning, every month, i have to go to each chart and add the current month and...

ok, the answer may be right in front of me, but i'm not seeing it... i created a hyperlink in a spreadsheet to open a separate existing workbook. i can open the file just fine if i do it manually (File - Open - etc.) but when i insert the hyperlink and click on it, i get this error saying...

Running into a bit of a head-scratcher... i've come along way on my own and am wondering if this last step is possible; thus i come and post. I have a list of enteries (numbers) each day that represents the number of 'clicks' a printer has made (each page printed is a click). so...

Hey everyone!! One of my roles is Document Control and in such position, I update 10000000000000000000000000 of documents (the number may be a bit of an exaggeration lol). to help speed up the process of protecting each document i created a macro. the thought was i would create a counter-macro...

hello all, I have a PivotTable that when i refresh the data, the value columns resize much wider than they need to be causing the table to stretch onto a second page; also causes my chart located to the right to get pushed around. Is there a way to turn this off? if not, what is it 'auto...

Ok, so I have a range of cells formatted as a Table. Some of the cells contain Data Validation Lists, some contain various formulas and a few are blank for the end user to populate. The first row works wonderfully but I've noticed 2 issues that I just don't understand: 1) I thought that if you...

Hello all... I have another question about Pivot Tables. Is there a way to change the default settings for new Pivot Tables? For example, everytime you create a Pivot Table it has subtotals turned on and under the Options dialog box for the PT, the option 'classic pivottable layout' under the...

Hello everyone... I dabble in P.Tables on a daily basis and have stumbled upon the slicer tool (new to 2010) on my own and have grown to like it more and more. playing around today, i noticed that under the properties of a slicer, it says 'Name to use in formula' the typically says something...