How do I get Excel to open a previously saved file?
With Excel not opened, all of sudden when I try to open an existing Excel
file, it only opens a blank workbook. I then have to repeat the action of
opening the file from the blank workbook. I am not sure what has happened but
I have always just been able to just click on the Excel file I want to open
and it would automatically open Excel and the intended file. Please advise
Make sure that Ignore other applications is unchecked.
that's all i can think of
"Jeff S" wrote:
> With Excel not opened, all of ...Excel 2007 3 Traiffic Light Conditional Formatting
Does anyone know how to get this to work using the 3-light conditional
formatting in Excel 2007 using the reference to another cell? I need it
pretty much the same way as listed above, but it is not working for me.
Here is the set up I currently have.
ROW 1 MTD ACTUAL BUDGET DIFFERENCE
ROW 2 120 120 130 -10
I want the 3-Light Conditional Formatting to be used on the MTD column with
this formula set up below.
GREEN LIGHT >= =D2=0
YELLOW LIGHT >= =D2=(-3)
Why is this not working? Any and every bit of help would be most appreciated!
AFAIK, you ca...Bug in CFrameWnd::OnInitMenuPopup (MFC 7.10)
If the command update handler deletes the first entry on the menu, no update
handlers are called for the remaining entries on the menu. This is due to a
bug in the following section of code from winfrm.cpp(1382):
// adjust for menu deletions and additions
UINT nCount = pMenu->GetMenuItemCount();
if (nCount < state.m_nIndexMax)
state.m_nIndex -= (state.m_nIndexMax - nCount);
while (state.m_nIndex < nCount &&
pMenu->GetMenuItemID(state.m_nIndex) == state.m_nID)
state.m_nIn...03 Outlook process continues after exit
After exiting outlook 2003, the outlook.exe process
continues to run. Upon trying to relaunch outlook,
nothing happens until after deleting outlook.exe process
in task manager. Any help out there?
How do I convert a pivot table to a pivot chart
My colleague Debra Dalgleish has posted this tutorial on my web site:
IMHO, pivot charts are a great idea whose time hasn't yet come. There
is a limited choice of chart types, the chart can be formatted only in
limited ways (you can't change the PLOT AREA!), the whole pivot table
must be included, and whatever formatting you may have applied is
obliterated when the pivot table is updated.
I generally make regular charts from pivot table data. In Excel 97,
whic...Change date format on report
My date displays as mddyy in the table but on the report I'd like it to
display as mm/dd/yyyy, how would I code that to have that field always
display in mm/dd/yyyy format. I'm thinking this is very simple but I just
can't get it to work for me.
Thank so much for your help.
On May 2, 1:50 pm, SITCFanTN <SITCFa...@discussions.microsoft.com>
> My date displays as mddyy in the table but on the report I'd like it to
> display as mm/dd/yyyy, how would I code that to have that field always
> display in mm/dd/yyyy format. I'm thinking this is very simple...Encrypt Text in Excel
I want to encrypt text in Excel. I want the character spacing to be accurate,
I just want the actual text to be encrypted to a user. Anyone know any
tricks, shortcuts, add-ins to do this?
One more note. It is the text in a given range of cells that I want to
encrypt. I've tried looking at different fonts and then locking the cells
(protecting worksheet) but none of the built-in Wingding fonts keep the
character spacing intact. I thought that maybe there was a way to do a custom
number or text format but wasn't able to get that to work.
...link Access workbook to Excel workbook
Can I link information from an Excel worksheet to an Access worksheet?
In Access, clic on File menu, External data, link tables and follow each step.
You'll have to define first row as heading label and that's it.
> Can I link information from an Excel worksheet to an Access worksheet?
...run an excel file remotely
i got an excel application that generates reports from
underlying pivot tables.
the reports are generated using excel 2003. but most of
the clients donot have licenses for 2003 and some of the
features of 2003 cannot be used when the file is opened
from the client system. for example GETPIVOTDATA is not
very flexible as it was in 2003 version.
So is it possible to run the excel application from the
server without being copied to the client system. This
also helps in maintaing single version of the excel file
rather than multiple versions on each client system.
Thanks in adva...Excel 2000 #15
We have a situation where all of the text keyed into a
cell does not appear when viewing or printing the
spreadsheet. If the user merged a row into columns from J
through W, it all appeared. If we inserted hard returns
into the entry into the cell, it also displayed. Has
anyone had similar a experience? If so how did you
Specs for Excel states that 32,767 characters can be placed in a cell.
1024 will be visible or can be printed.
Using ALT + ENTER to get hard returns will increase this limit.
Gord Dibben Excel MVP
On Wed, 14 Apr 2004 07:20:58 -07...Budget Wizard for Excel
We're running Dynamics GP 10.0 Advanced Management Edition. The Budget
Wizard for Excel is not checked as a registered module. Is this
separately licensable? I thought the budget/excel import export
utility was a built-in feature.
The export functionality works but we're unable to import an excel
Can someone shed some light on this issue?
Go to Microsoft Dynamics GP menu >> Tools >> Setup >> System >>
Registration, and make sure you didn't uncheck it from the selected modules.
Mohammad R. Daoud
MCP, MCBMSP, MCTS...Pictures in Excel cells
I want to create a book with personal descriptions, including pictures.
But how can I get a picture in an Excel cell?
I thought that =HYPERLINK("file.jpg") would be the thing, but the
pictures are not retrieved when I combine the Excel sheet to the final
Do you object if ...
Alt > i > p > f
and select the picture what you want to import.
"Jose" <email@example.com> wrote in message news:firstname.lastname@example.org...
> Dear friends
> I want to create...Excel 2002 configuration
This is a multi-part message in MIME format.
Is there any way to disable the little green corner marker in the top =
left of cell for all cases where the formula references empty cells?=20
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>...eConnect 10.0 SDK (version prior to SP1 & SP2)?
I am reposting this question, as I am yet to succeed in finding the correct
link to this download.
I need eConnect 10.0 SDK, version prior to SP2, since SP2 require the basic
version to be present. And I do not have this installed.
I checked PartnerSource, but it is leading me to SP2 install page.
I sincerely hope someone assist me in finding the correct link in
> Hi All,
> I am repostin...Max Date + condition
In column 1, I have dates. In column 2, I have criterias. How can I ge
the max date matching criteria in column 2.
How to get max date of AA ? I should get 2004-08-02
Message posted from http://www.ExcelForum.com
try the array formula (entered with CTRL+sHIFT+ENTER):
>In column 1, I have dates. In column 2, I have criterias.
How can I get
>the max date matching criteria in co...Smart List export to Excel #2
We are using Dynamics 9.0 and Office 2003. When we try to do a Smart List
export to Excel, we keep getting an "Exception_Class_Object_Exception" that
references varying object errors, such as 'Cells' or 'Value'; the object
errors will change each time we try an export. As a workaround, I've found
that closing Excel before doing the export allows the export to complete
successfully. However, that solution isn't acceptable, as our Dynamics users
would like to be able to work in Excel, doing other tasks, while the export
is processing. Does anyone...excel html user area import
Im using excel 2007 and having problems with importing html.
Problem is that I need to import data from html page which is in user
area( username and password protected).
So data imports ok, but when I exit saved excel file and then open it again
, it can't refresh data because i'm not logged in.
How can i solve this problem?
Can I add some html form to excel so I can logon with that form, so I can
...Excel 2007 slow saving with defined names
I am using a worksheet with a lot of defined names. Saving this sheet in
Excel 2007 takes about 5 minutes! In previous Excel-versions the same
worksheet saves within 10 seconds. Does anyone have an idea to improve this
Probably Windows Vista has something to do with this problem, because:
- Windows XP and Excel 2007: fast saving
- Windows Vista and Excel 2003: fast saving
- Windows Vista and Excel 2007: slooooow saving
...Excel charts in print preview distorted.
I'm assisting a customer with an excel presentation she
created on another computer. She is curently using Excel
XP and she changed some of the data the charts are pulling
from and now the charts are all distorted in print
preview. The charts are all scrunched up in the upper
portion of the page. I view this presentation on my
computer and all looks fine in page layout and print
preview. I tried setting her default printer to mine, no
help. I tried adjusting her video resolutions (they were
originally the same as mine) to higher and lower
resolutions and get the same results. Any...Important dates Gone
Went from 2003 to 2004.
In 2003 I had money express and my home page show important dates. Via the
options the dates are still there. But don't show up any more? Anyone knows
how I can fix this?
...Excel Automation Resizing.
I am wondering if anyone knows how to have an excel sheet
fit entirely in a window's view for an MDI application,
and resize itself when the view is resize. I would
appreciate any help you can give. Also, is there a website
that has the Excel object model interfaces for MFC?
...set excel always on top
Can I set excel to always be on top? I am using excel with a half screen and
other programs and want excel to be on top as I switch between the other
that is a windows question. this is excel workgroup.
>Can I set excel to always be on top? I am using excel
with a half screen and
>other programs and want excel to be on top as I switch
between the other
Take a look at this post:
&g...Date Header and Layout Questions
I have 1 table with headings of:
On a report, I want the header to show every Monday's date going
horizontally displaying every Monday from now until 2 years from now. Then I
want the Vertical column to be the TaskType. Within the report I want the
SiteName to be identified in both the Monday's Date Column and the TaskType
For example, 30-Nov-09 (Monday) TaskType-DSR SiteName - DC. The date being
on the header, the TaskType on each row and the SiteName cross referenced
Does this make any sense?
...Excel password #2
I've an old worksheet in Excel 2k,
and I forgot the password I saved with it.
Is there a way to retrieve it?
Workbook password to open????
If so, here's a post by Norman Harker that should give you a start.
If it is a workbook password then here is the standard post on that one:
The following sites advertise ability to recover, amongst other things,
Excel file passwords. These passwords are imposed when saving Excel
and are not to be confused with *internal* passwords on sheets and
http://www.i...zones in excel charts
I'd like to be able to set up zones in an Excel chart. Imagine a bell curve.
Areas under the curve within one standard deviation could be green, those
between one and two standard deviations would be yellow, and those more than
two would be red. Or I can have an X - Y scatter chart. If the X-axis runs
from 0 - 10, I might want 0 - 3 as red, 3 - 5 as green, and 5 - 10 blue.
Just as an example.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I