Link from Excel to out look
I would like to make a link from Excel date column to my outlook calander.
Please let me if it is possible. I am using Office 2003. For example if I
have date in one column and some notes on second column. For that date I
would like see those notes in my Outlook Calander.
...Excel 97 not saving
I have a user on WinXP / Office 97. User states that
sporatically, she is unable to save an Excel file on
either her hard drive or the network drive. These files
have macros in them, and up until she was upgraded to XP
and began using macros, she had no problems saving. The
only error being reported is "Document could not be
In her latest email to me she writes: Please note that
the problem is intermittent and I do not know what is
triggering the problem other than it has only happened
since I started using XP and files with Macros.
I have seen documentation that a...Outlook keeps prompting for logon..
User is on Outlook 2k3, latest service packs, updates, etc. Mailbox lives
on Exchange 2007 (SP1). Everytime the user starts Outlook they're prompted
to logon. I've disabled the logon prompt at startup option (and enabled it
and then disabled it again), but it's still happening.
I've tried it with cached mode on and cached mode off.
I've tried it with offline mode enabled and disabled.
I've tried deleting his profile and recreating it.
I've tried switching to an RPC/HTTPS connection.
Finally, i completely uninstalled Outlook 2k3 and installed Outlook 2k7.
Not...How do I bridge the gaps in data in (XL 2007) Area Chart
XL 2007 doesn't have the TOOLS-Options-Interpolate menu and choices.
This goes for a line chart as well.
Click the chart to activate it
In the Design tab of Chart Tools, click Select Data
A dialog box opens, look at lower left corner for "Hidden and Empty Cells"
button and click it
You get three options: gaps, zero and connect.
Alternative (works in all version of Excel); in the empty cell type =NA().
It will display as #N/A and will be ignored by the chart engine
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
...Opening Excel files in Explorer
Usually you can open any excel file by double clicking the file from within
Windows Explorer. Since some time for a mysterious reason this doesn't work
any more. Excel opens but not the file. Any ideas why this is so and what to
do about it?
Tanks for info,
Sometimes one of these works:
Tools|Options|General|Ignore other applications (uncheck it)
--- or ---
Close Excel and
Windows Start Button|Run
Windows Start Button|Run
The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults...problem with column charts and two Y axes in Excel 2003
I've used previous versions of Excel for column charts a fair bit, and
it seems like something doesn't work in Excel 2003. I want to display
two data series next to one another in a column chart, and each data
series needs its own Y axis (they are on different scales). I can get
the two series next to each other if they are both plotted against the
same Y axis, but if I choose Format Data Series -> Axis -> Secondary
Axis for the second data series, the two columns are on top of each
other. I can't figure out how to change this, and I don't recall ever
having this probl...I need Excel Help
I have another question about my project that I don't understand, if anyone
could help that would be awesome!
consultants who work on a project also receive a bonus if the fees exceed
estimates, otherwise the consultant received no bonus. Create one formula
that calculates the bonus by referencing the appropriate bonus rate in the
table given by
the number of hours the consultant worked.
Does this make sense to anyone? I really need help.
Take a look at VLOOKUP in help.
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"IHate...Trouble exporting Report to Excel
How do you increase rows to output size? When exporting a 2000+ page report
to Excel (97-2002 *xls), stops on page 412 with message stating: “There are
too many rows to output, based on limitation specified by the output format
or by Microsoft Access”. Using Access 2000 with Windows 2000 OS
Excel has a hard-and-fast limit of 65536. When you export to Excel from a
report, you usually get extraneous blank lines, so it's conceivable that
you're hitting that limit.
There's no way around it, other than to simply export the data (assuming
less than 65536 rows) rather than the rep...My worksheet automatically adds a fill color when I enter text.
When I type text in a blank cell, the cell automatically is highlightes with
the bright yellow fill. There is no conditional formatting on this workbook.
Check your VBA editor.
You might have an Event Macro which does what, usually, a CF does.
Try to Increase the Macro Security to its maximum level in order to
eliminate the Event Macro from running...
You may, also consider to "rem" all the Macro commands by adding a Preceding
apostrophe to each command.
> When I type text in a blank cell, the cell automatically is highlightes with
> the bright yello...Help Old addresses keep coming up
When I go to send an email to some people their old email addresses keep
popping up together with their current ones. I do not have them listed in
contacts or in an address book. It is a minor annoyance. I am using Outlook
2003. It is a minor annoyance. How do I delete these old addresses? Where
they show up is where I am entering the e-mail address on the item being
You did not specify how you were entering the addresses. Presumably you are
using autocompletion and they are...Excel File Opening Via Hyperlink
What do I need to do within an Excel document to have it open in print
preview mode when the Intranet link to this file is clicked?
Put this one line Macro in the ThisWorkbook code area:
Private Sub Workbook_Open()
Gary''s Student - gsnu200723
...Excel Type Rounding
Am using A2k. Want to round numbers to thousands. With Excel I use
Round(number, -3) for this. However, dont know how to do it with Access
standard Round() function. The same syntax produces an error with Access. Pls
For example, I want 125,232 to be displayed as 125,000 and 125,832 to be
displayed as 126,000
> Am using A2k. Want to round numbers to thousands. With Excel I use
> Round(number, -3) for this. However, dont know ho...Duplicate records in Excel
How do I highliht duplicate records in Excel?
I created a data base in Excel, and discovered that there are duplicate tag
numbers from the old paper work I'm pulling data off of. So I'm looking for
a way to get Excel to find those duplicate records and highlight the rows
they are in.
Sheidsa, have a look here http://cpearson.com/excel/duplicat.htm
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Sheidsa" <She...Confirmation of receipt keeps trying to send and fails
I received an email message that requested a confirmation that it had been
received. I told it to send confirmation, but it failed when attemtping to
send it and produced an error.
I tried deleting the email message and everything in the draft items and
Outbox, but every time I switch on Outlook the darn thing tries to send this
email confirmation. It seems there is nothing I can do to stop it, even
though I cannot see it!
I have tried uninstalling Office 2003 and reinstalling it, but all of my
settings are remembered as are all the old emails. I just cannot seem to
get rid of it!
...Access 2 Excel
I exported an annual worklist from an Access table to Excel. There is
column for tasks, one for frequency (TD, D, TW, W, TM, M, Q, SA, A
twice daily, daily, twice monthly, etc) and a column for each month.
The month columns have the same coded data as the frequency colum
depending on when the task is done.
The problem is that I tried to make a pivot table to count how man
tasks (by frequency type) are done each month. Excel is counting th
empty cells as if they had data. Search and replace doesn't work.
even tried replacing the blank data in Access with ~ and re-exportin
it. Ex...Excel VBA Project Has Protection?
I'm trying to find a way to programmatically check if a workbooks VBA
project has protection.
I know ActiveWorkbook.VBProject.Protection will tell you if it is
currently locked but that doesn't help if the project has already been
unprotected ie by a user (or another bit of code) has unprotected the
So what i am trying to do is if a VBA project doesn't have any
protection, my code will ask the user for a password and then set the
password by using sendkeys. If they already have the VBA project
protected, it will ask them for their password, then unlock the
pr...Keep Lines Together; Keep with Next
I'm working in Vista. When I select lines and click on "Keep Lines
Together," the lines do not stay together. They stay together if I also
click "Keep with Next," but I'm working on a booklet in which the pages are
1/4 of a letter-sized page, and a lot of space (4 lines) is left at the
bottom and wasted if I also click "Keep with Next." Why won't "Keep Lines
Together" keep the lines together? The project is a small, bound country
club booklet, with names, addresses, phones, etc. Each entry might be 2, 3,
or 4 lines. Any h...why do my pictures keep disappearing?
Although I have checked the box in 'pictures' any form of graphic or word art
that I have inserted into my publication keeps disappearing! If I click in
the general direction of the insertion the bounding dots appear, but no
Are you sure you have view, pictures, detailed display checked? If so try updating
your graphics driver...
Mary Sauer MS MVP
"JG" <JG@discussions.microsoft.com> wrote in message
> Altho...Excel graphs
I'm trying to display two sets of data, with identical X-axis on the same
Y-axis, but am finding it hard. I don't want 4 bars for each X value, but a
graph with 4 X-catergories containing 2 bars each, then an identical x-axis
with a further similar data set (i.e. 4 x 2 bars) - anyone have a clue how to
do this? I've tried just making two graphs and deleting the Y-axis from one,
but the X-axis never line up in something like Powerpoint when I put them
Forgot to say, this is for Excel 2000 bar graphs.
> I'...opening Excel and then closing it
I have a file that is passed to me in XLS format, but I would much prefer to
work with it in CSV. So I did this...
' open the downloaded file in Excel and copy it over to L in csv format
Workbooks("D00100001554_0.xls").ConflictResolution = xlLocalSessionChanges
Workbooks("D00100001554_0.xls").SaveAs "L:\Activity.csv", xlCSV
This works fine except it leaves Excel open in the background. The only
thing to do is fine it in Processes a...How to do this kind of chart in excel?
I wonder if this is possible.
I have two gaussians represented by points and joined by a smooth line in
however, ideally I want the area under the curves to be shaded, and best of
all, if possible, be semi transparent so that the overlap between the two
curves is highlighted a bit darker than the area under the individual
x values are wavelength, y values are intensity
is this possible?
Excel doesn't do transparent shading of area charts; otherwise that
would be the ideal approach. You can get semitransparent column charts
using an autoshape as an area...how can I keep a tab in place?
I have workbooks with multiple worksheets. I would like to keep the summary
tab in a fixed (first) position so that the user can easily, quickly find it
without using the l<, <, >, >l (arrow) tabs.
I use hyperlinks to get from the summary tab to the other tabs, and I know I
can hyperlink tab back... but I'd rather not use the hyperlinks too much.
Tools - Protection - Protect workbook (for structure)
Or, create a custom button/macro that navigates to the summary sheet.
"missy8892" <firstname.lastname@example.org>...create charts using concatenated ratios (e.g. 1:250, 1:325, 1:10)
I've written a formula that produces rations (e.g., 1:250) by concatenting
"1:"&(a6*w34). How can I persuade Excel to draw charts of the results? It
wants to interpret them all as "1" Thanks for you help.
A concatenated cell contains a string. XL can only plot that on a
Category axis (x-axis for charts such as Line, Column, Area). It
cannot use a string for a y-value.
What you may want to do is plot the decimal equivalent and then use the
ratio column as a label for the plotted series.
Excel, PowerPoint, ...microsoft excel #4
Whre I can find in the web to download microsoft excel
I'm not sure what you mean - Microsoft Excel isn't a free software
application. If you can find it out there as a public download on the web
I'm sure that Microsoft would want to know about it.
"budors" <email@example.com> wrote in message
> Whre I can find in the web to download microsoft excel.
You cant download it, not legally any way, you have to BUY it, strange as
I am trying to open a file in excel, but when file is loaded about 50% , i
get a report with an error.
I tried to open an excel file and it works.