General

How can I detail Pivot Table data without creating a table (Excel 2007)
Hi.. I would like to know if there is a way to detail pivot tale data without creating a new table, or in other terms, without the need to convert it to a range? Thanks in advance. Kind regards, SkELeTikO P.S. I'm currently using Excel 2007 ... 4 May 2010 20:13

share workbook error
I am using excel 2007 and am trying to share a workbook. review/share workbook Then I get the message that the file is no longer shared. How can I share the workbook? ... 4 May 2010 20:13

Non-matching cells
Excel 2007 Advanced Filter With optional macro. http://c0718892.cdn.cloudfiles.rackspacecloud.com/05_04_10.xlsm Pdf preview (2 pgs): http://www.mediafire.com/file/mjj2mtyqj0n/05_04_10.pdf ... 4 May 2010 19:06

Excel chart does not start at zero.
I have a chart that shows shipped quantities vs month/year date, with the date on the x-axis. My manager, who is expert at finding trivial things for me that take up hours to accomplish, asked me to make the leftmost data point Jan 2009, and to make the graph series line intersect with the y axis - currently, ... 5 May 2010 12:40

Non -matching cells
"GARY" <gcotterl(a)co.riverside.ca.us> wrote in message news:c706c527-240d-4e20-b0e1-0fc7e45e727a(a)42g2000prb.googlegroups.com... COL A has 800,000 cells COL B has 750,000 cells Here's an example of my spreadsheet: A B 008101966-1 008101966-1 008101968-3 008101968-3 ... 4 May 2010 19:06

How to list the rows that match a particular query?
I have a worksheet with a lot of rows. I'd like to see all the rows in the worksheet that match a particular "query", like "column A = 'foo' || column B = 'bar'". How do I do that sort of thing? ... 4 May 2010 19:06

Printing Problem
I have a spreadsheet with a picture on the first page. When I look at the spreadsheet in any of the Excel views it looks great however when I print the spreadsheet the logo almost doubles in size covering data on the spreadsheet. I have noticed that some other of my spreadsheets have started doing the same ... 4 May 2010 17:59

Filtering
How can I search thru an entire workbook for a keyword and return the row? I would like it to behave just like filtering just on the whole workbook. ... 4 May 2010 17:59

Automating a task list
I am in need of some ideas. I am attempting to put together an automated cleaning list for one of our locations. What is the best way to do this? The tasks fall daily, weekly, etc. and may change. Once they are in their respective catagories (daily weekly etc) what is the best way to get them to fall into their... 4 May 2010 17:59

Pivot Table Calculated Field
I have a pivot table in which the data area includes a 'count' of a text field. I am trying to create a calculated field which will divide the sum of a numeric field by this count field but it doesn't seem to be working. The formula looks as follows: ='sum Field'/COUNT(data field). The result I am getting is ... 4 May 2010 15:42