General

Pivot Table - too many rows/columns error
Friends, The data I am accessing for my pivot table would comprise only 500 rows if Excel would let me put the 5 rows into the Row area, but I get the following error message: "Microsoft Excel cannot make this change because there are too many row or column items. Drag at least one row or column field off ... 2 Feb 2006 01:28

Excel and Quickbooks
Hi all, I'm working on setting up a speadsheet in Excel using data from Quickbooks (an accounting package). I have the speadsheets linked but every month I have to redo the links because when I export from Quickbooks into my excel spreadsheet it creates a new page in the workbook. I need to overright the inf... 2 Feb 2006 10:53

Show % Difference between two numbers
I am trying to show the percentage difference between two numbers and also show the overage in red....Help! ... 3 Feb 2006 14:31

Excel 2003 - Freeze panes
?Is there a way to freeze panes both vertical and horizontally at this same time ... 1 Feb 2006 11:24

Waterfall cashflow distribution
Here's another cashflow problem. And it has two parts. Part 1. The Limited Partner (LP) and General Partner (GP) make contributions on a 90%/10% ratio. Here's an example cashflow. "Year" is A1. A B C D Year LP GP NCF 0 -900 -100 -1,000 1 0 0 50 2 0 0 175 3 0 0 170 4 0 0 180 5 0 0 185 6 0 0 190 7 0 0 200... 31 Jan 2006 18:39

Outlook Template for Student Use Based on Points
It would be helpful and time saving for me if I could get a grade tracker for student use based on points for multiple subjects. They have a nice one based on percentages but it does not work for my classes. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions wi... 31 Jan 2006 18:08

Creating UPC Codes...
Hey people, first timer here. Didn't exactly know where to put this, so I followed the big red typing... Anyway, currently, we use excel to create UPC codes for our products. I was wondering how to make it more streamlined, and possibly automatic... Let me explain how it works. Columns A-F are six seperate fi... 31 Jan 2006 17:37

Locked for editing
Sometimes when I open Excel after it shut down unexpectedly I get the message: "File in use. Insert visio button.xls is locked for editing". I can only open my files read only. I have the shutdown my system completely to get access to the files again. Does anyone know why this happens and how to solve it? Re... 31 Jan 2006 16:02

Excel - formula help needed
Help please!! I am finalizing a payroll accrual file and would love it if there was a way to speed up this process every year. Does any know the formula to get the remaining weeks in a year based on various date fields? In other words... an employee accruing his 1st 40hrs of vacation would be... Emp#123(A1)... 31 Jan 2006 12:23

Japanese Yen
Hi Is the sign for Japanese Yen available in Excel? I can't find it in the currency box. Thanks Richard ... 31 Jan 2006 08:42