General

Forecast with two unknown variables
I'm hoping this is an easy question but I can't figure it out for the life of me. I've simplified my scenario down to two variables, order quantity and order frequency (represented by the number of days between orders). I want to predict a customer's next order date and quantity based on past order history.... 30 Apr 2010 17:27

How to close file and hibernate?
I would like to close existing file and go hibernate, but once this file is closed, the command hibernate cannot be run. On the other way, I run the hibernate, which work, but the file cannot be closed. Does anyone have any suggestions on how to close file and hibernate XP? My PC is XP with SP3 and using office ... 4 May 2010 15:42

Smooth out pie
I have a pie chart but the "pieces" of the pie have jagged edges. The help menu tells me to: Click the line data series you want to smooth. On the Format menu, click Selected Data Series, and then click the Patterns tab. Select the Smoothed line check box. ............ But there is no Smoothed line check bo... 1 May 2010 19:49

External data into Excel 2007
I have a workbook with several sheets with a query attached which prompts for a parameter. Each shhet gets a different value for the one parameter. My problem is, when I run the query, no matter which sheet I'm on, the data gets returned to sheet one. What am I doing wrong ? ... 30 Apr 2010 16:19

Issues with VLookup, Please help!
Hi, first off, first post and thank you for being such a great community. Also, I might need your help as I am facing a wall. You guys are bulldozers so it should be easy enough. Alright, I am using Excel 2003 and I am trying to automatically fill a VLookup formula in different cells that are not adjacent to each... 1 May 2010 05:29

Send email from vba code in excel
Help! I need to write code to send a work book when it is saved or when it is closed. This is what I have but it will not send the email. I am using excel 2003. I am very new to VBA. Sub Email() Dim OutApp As Object Dim OutMail As Object email_ = Range("F5") & ";" & Range("F3") cc_ = "" subject_ = "Flagged Or... 16 May 2010 15:44

General Setting Question
I think I have modifed setting and I am not sure which one it is. I am running 2007, and I have changed something so that when I click into the formula bar to edit an equation, I can no longer drag the cells to adjust the equation. There used to be bold outlines around the cells involved in the equation, whi... 30 Apr 2010 16:19

Setting up a bi-weekly calendar event
I am trying to create a 12 month calendar at work to post a class that is given every other Friday. Is there a way to formulate this without tying each class in individually. ... 30 Apr 2010 15:10

style menu, excel 2007 sp2
Is there any way to turn off the "mini" menu of all the styles? I really just want the "conditional formatting" and "format as table" buttons, instead I have a bunch of additional formatting options. Thanks. ... 30 Apr 2010 15:10

Excel 2003 & Sharepoint
Hi all, I have a user that has Excel 2003 installed on her system. My company is using SharePoint as a Doucment Control Center for all of our company's documents. I have one user that I am having a really hard time diagnosing. One of my users can open spreadsheets if they are checked in and in a approved statu... 30 Apr 2010 14:00