Excel 2003 - Vista
Sat, 28 Jun 2008 10:31:00 -0700
I just installed the Windows Vistas Service Pack 1. Now the yearfrac
function and FV functions don't work. Anytime they appear in a workbook, I
get "#Value!".
Before installing the service pack, I had this same problem twice, and it
got my functions back by uninstalling MS Office 2003 and reinstalling it ...
|
2007 won't run the following vb works in 2003
Fri, 27 Jun 2008 10:51:02 -0700
I'm using the following in 2003 excel but it will not run in 2007!
Any help would be great.
Private Sub Worksheet_Change(ByVal Target As Range)
v = Range("c2").Value
If v > 500 And v < 1001 Then
Range("C3").Value = v
End If
If v > 1000 And v < 25001 Then
Range("C4").Value = v
End If
If ...
|
Formula Question
Fri, 27 Jun 2008 06:46:02 -0700
I need to create a formula that will find text and then return the number.
See below.
LOC STAT FACILITY PROF
ADJ VOID 0 0
COB COB 0 0
COB LNLVL 0 0
COB MED 0 34
COB PEND 0 0
I need the formula to find the matching STAT text and then return the value
found in FACILITY OR PROF field. The STAT fields ...
|
Excel is duplicating menus
Thu, 26 Jun 2008 19:44:01 -0700
I'm running Excel X for the Mac.
When I right click the mouse or use the ctrl key to activate menu options on
a ow (Help, Cut, Copy, Paste, etc.) something screwy happens and the menu
options keep multiplying (Help, Cut, Copy, Paste, Help, Cut, Copy, Paste,...)
This does not happen when I right click on the ...
|
Sort Menu Item Disabled in all workbooks
Thu, 26 Jun 2008 13:15:01 -0700
Office Pro 2003, SP3 -- Excel.
Suddenly, for no apparent reason, the Data-->Sort item is permanently
disabled on my PC. This is true for old workbooks and newly created
workbooks.
The Toolbar sort buttons work just fine.
I do a fair amount of VBA development, but have done very little lately.
I have no prot ...
|
HELP!! Auto Filter Locked!
Thu, 26 Jun 2008 10:11:02 -0700
I finished creating a huge database and had been using the Auto Filter to
help me plug in data and analyze it. When I finished in the particular column
I was working on, the black arrow that appears when you turn the feature on,
had turned blue and now I can't Auto Filter anything in the entire
spreadsheet. ...
|
can I use Excel Viewer control in asp.net?
Thu, 26 Jun 2008 01:19:01 -0700
I want to display the excel sheet in a web form, with restricting user not to
change or save excel file. Can I use, Microsoft Office Excel Viewer 2003 in
Asp.Net? Can u please suggest me how to do it? ...
|
|
|
unable to open my excel file & excel crashes
Wed, 25 Jun 2008 16:33:01 -0700
excel file is 33 mb and 'm using everyday
for the last 2 days the file wouldn't open and the excel crashes. the error
message I get is "Microsoft office excel has encountered a problem and needs
to close. We are sorry for the inconvenience"
When I open the error report the message is " AppName: excel.exe ...
|
Excel 2000, pasting error **New**
Wed, 25 Jun 2008 13:02:03 -0700
Hi, could someone please help me with an issue one of our workstations is
having?
Once the cell(s) have have been selected and copied, and you go to paste the
data in any other location on the worksheet or workbook, this same dialog box
pops up.
"This feature is disabled because it is not compatible wi ...
|
Loss of Data when converting to Excel 2007
Wed, 25 Jun 2008 12:03:01 -0700
I have a file that outputs 4 charts and 4 tables for a workbook. The workbook
works completely fine in Excel 2003, but when saving it in Excel 2007 only
one chart and one table shows. Then I recieve a error for an Invalid
Parameter. Could somebody please help me with my problem. ...
|
