Hiding and unhiding columns "toolbar"
I have a worksheet with a "toolbar" that allows me to
toggle between hiding and unhiding pre-set columns. I do
not have access to the author so I am seeking help. Can
anyone tell me how to create and delete this bar?
The bar is located at the top of the sheet, just below
the customizable toolbars. It has two "checkboxes" on the
left, one containing the number one, the other the number
2. By clicking on the 1 or 2 I can toggle between hiding
all the hidden columns or unhiding them. But I cannot
delete or modify the bar, which I need to do.
Can anyone help?
You ca...Heads-up to users of "Bitdefender"
A simple heads-up to users of "bitdefender"
Disclaimer: off-list followups get on-list replies or get ignored.
Please do not ignore the Reply-To header.
...Importing Contact DL's into DL's on the GAL
I'm trying to find out how to import distribution lists located in Contacts
in an exchange mailbox into exchange so that they are available for everyone
on the GAL
There are about 1000 DL's so it is not possible to do this one-by-one. The
DL's contain Display name and smtp address as members.
Please - suggestions :D
Brendon B <BrendonB@discussions.microsoft.com> typed:
> Hi Everyone
> I'm trying to find out how to import distribution lists located in
> Co...Error: "Unable to open your default e-mail folders. The microsoft exchange server is unavailable"
I have a user on our exchange 2003 sp1 system who is receiving the
above error when trying to connect to his mailbox. He is able to
connect in OWA. I gave myself rights on his mailbox and set up a new
profile on my machine (xp, office 2003) and connected fine. I then
logged in as his account on my machine, set up a profile and tried to
open outlook and received the error above.
Any ideas. Not seeing this exact error on the microsoft site or google
...Unable to bulk import leads
I'm trying to bulk import leads into CRM 3.0, but everytime I get an error
complaining about insufficient privileges. I'm a member of all roles, and I
also change all role privileges to have Organization access to bulk import.
The I change the workflow service to run under localsystem. No help.
What else could I try ? Since it's about missing privileges, is there a log
somewhere that would indicate more details ?
...Where to change my own internet adress in "FROM:" field?
I am using Outlook 2003 with Exchange server.
My own eMail address is presented to recipients as
Note: mixing of capital and lower letters
I want my email address completely changed to lower letters:
Where in Outlook can I change this?
or is this a setting in Exchange Server ?
This is a setting in ADUC/Exchange. I would guess that everyone is set up
with the same format throughout the company.
Kathleen Orland - MVP Outlook
Outlook Tips: http://www.outlook-tips.net/
"Joe deAngelo" wr...WHAT DOES THE SYMBOL"$" REPRESENT IN A EXCEL FORMULA?
SORRY FOR THE NOVICE EXCEL QUESTION - IM JUST LEARNING THE PROGRAM AND CANT
SEEM TO FIND IN "HELP" ALL SYMBOLS FOR FORMULAS
It's used to create an absolute cell reference, i.e. one that will not be
changed even when the formual is copied and pasted.
Without the the $ symbol, a formula such as =A1+B1 in cell C1 would be
changed to =A2+C2 if it was copied into cell C2, whilst this is useful if
you're creating a table of information, it can some times be a pain.
By changing the original formula to =$A$1+$B$1, it will not change when
The above example keeps it en...Stock Bonus
I have money 2005 premium and I use it to track my overseas stocks.
Occasionally I receive bonuses where for example I get 1 stock for
every stock I have. So lets say I have 20 stocks of company XYZ, and
they issue a bonus of 1:1, I get another 20 stocks as bonus. Is there
a way to add this into money? I guess I can obviously go and record it
as a buy but I am looking for something similar to using the split I
Thanks in advance.
In microsoft.public.money, deepiceman wrote:
>I have money 2005 premium and I use it to track my overseas stocks.
>Occasionally I receive bo...Auto-backup fails if "tmp" is on a FAT32 drive
Now this is weird. Money 2003 (which works almost perfectly for me) balks
at creating the automatic backup at program exit, IF the environment
variable "tmp" points to a folder on any FAT32 partition. A dialog box
says that Money cannot create a temporary file on P:\Temp. The folder
exists, and it's not marked read-only. (Since it's FAT32, it shouldn't be
a permissions issue.)
If "tmp" points anywhere on an NTFS partition, Money 2003 creates the
backup on exit just fine.
Although the message says that Money "cannot create a temporary file",...Lack of disk space for stock split?
I have a stock split that I need to enter in Money 2001 Standard Edition
(yes, I know it's old, but upgrading is not an option now). When I try to
enter it, I get the message, "The stock split could not be completed due to
lack of disk space." (There's plenty of space on the hard disk, of course.) I
have tried archiving old transactions, I ran scandisk & defrag, and even
tried doing a split in the sample file (which worked fine), but nothing has
fixed this. I could change the original buy orders to the split-adjusted
quantities & prices, but I'd rather fix ..."Move to bottom of range"
I have some code that adds the contents of one sheet to the end of
another. How do I correctly select the first empty cell below the first
sheet that I want to add data to?
'Move to bottom of range
^^^ This is where I need work.
Can I simply perform a cursor key move down one cell?
How do I code cursor key operations?
It is very unlikely that you will need to select a cell to do what you want
but here's a couple of methods
Select empty cell after last used cell in col A
R...Bill of Materials Import
I'm having trouble import Bills of Materials. Can someone provide me with
sample files or any advice?
Are you importing manufacturing BOMs or inventory BOMs? I've done
integrations for manufacturing BOMs using the direct to table adapter. I've
also got a doc from MBS on importing manufacturing BOMs to 8.0. If you'll
e-mail me (email@example.com) I'll forward that to you.
> I'm having trouble import Bills of Materials. Can someone provide me with
> sample files or any advice?
> Tha...Pink Sheet stocks
I am using MS Money 2005 Premium, Version 126.96.36.1995 and have
recently had a need for Portfolio Manager to list and update the
price on a stock that slipped into the Pink Sheets. I can not get
Money to recognize this stock symbol, although it is valid in
Yahoo. What do I need to do, or does Money not stoop to that
This stock ABRXQ.PK is one I made the bad judjement of keeping
when it fell from grace. It opened this morning in the Pink
Sheets. This was ABRX a few days ago, then it was delisted from
the Nas and became ABRXQ. This morning it was handed off to the
pink sheets and acquir...Import and Export from/to Excel query
I need to import and export Excel files in and out of Outlook 2003. When I
try and do it I am told I don't have the correct translator and do I want
to install it - when I say yes it tells me to put in the CD - when I put in
the CD it doesn't install but just freezes up and I have to cancel - the
file it tells me I need is L4561403.CAB
How and where do I install L4561403.CAB which I assume that I can find on
TIA for any help.
KiwiBrian <firstname.lastname@example.org> wrote:
> I need to import and export Excel files in and out of Outlook 2003.
> When ...Importing data via macro
I want to create a macro, which let me automate the process of importing the
data from various files (*.xls) from a particular directory to the main table
in MS Access.
My Main table in access is called Wire Transfer Main table. And every
Monday few specialist go in a share drive and post their completed forms in
..xls format. My macro should go into that shared directory every week and
pull out the files from that directory and copy the data from those files to
my Wire Transfer Main Table in access database.
Liz - you're probably better off if you writ...Office Standard 2003, no more activations left by phone or online
I have used all of my activations, online and by phone. Am I out of luck and
need to purchase a new key? Is there a way around this?
If its a retail version you can install as often as you like providing you
dont exceed the number of *working* PC's its licensed for.
If an oem version its only licensed for the origonal PC
"BettyBlue" <BettyBlue@discussions.microsoft.com> wrote in message
>I have used all of my activations, online and by phone. Am I out of luck
> need to purchase a new...Check important pack for MS Internet Explorer
Content-Type: multipart/related; boundary="agtsvbarlkrqvjpnc";
Content-Type: multipart/alternative; boundary="tmpcbwupucpalmpj"
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
In...Help Fixing Data on Item Stock Status display
GP 8.0, SQL
Had an employee "sell" 9,000,000,000 units of an item at $0 price. Instead
of deleting the line, he $0 the price. The invoice was posted. I discovered
when our income statement showed a loss of $42b!
My first mistake was to try and reverse by creating a return for the same #
of units at $0 price. But somehow this created problems with the inventory.
Basically, I messed around with it with a number of invoices/inventory
I discovered how to void the RTN and INV using utility > sales > remove
sales history. This had the desired effect with one exc...Can't close quote
I am trying to close an opportunity that has an active quote. When I try to
close the quote, I get the following exception:
Unhandled Execution Error
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can b...Importing e-mail addresses
I am trying to import many e-mial addresses from a word 2000 doc to my outlook 2000
I can change the format of the word doc to txt etc. but I cannot seem to get the e-mail addresses into Outlook 2000
I need the addresses to be in my contacts lists. and distribution list
...Graph Standard Deviations
I have about 40 points that I wish to graph. I used these points to get a
logarithmic trendline. Now I want to graph one standard deviation above and
one below. How do I do that.
> I have about 40 points that I wish to graph. I used these points to get a
> logarithmic trendline. Now I want to graph one standard deviation above and
> one below. How do I do that.
I'd use helper columns. Compute the values for the +/- sigma at each X value
and then just add them to your graph in the normal way. There may be something
more clever, but this should work.
Go...Designation is not importing into resource center with resources
I synchronizing project server 2007 with Active Directory.
after synchronization there is one field AD which is designation of the user
.. which is not import into project server .
I want Designation also import into project server with synchronized
how to do this
You would need to write your own sync routine. The built-in synchronization
routine is not extensible.
Gary L. Chefetz, MVP, MCT, MCTIP
"Sam" <Sa...Exchange SP2 "Move All Replicas"
Was curious if the "Move All Replicas" feature will move Public folder
replicas from Exch2K to Exch2003 w/sp2? Also, does it matter if some folders
are already replicating?
On Wed, 12 Apr 2006 13:22:02 -0700, Jim@bg
> Was curious if the "Move All Replicas" feature will move Public folder
>replicas from Exch2K to Exch2003 w/sp2? Also, does it matter if some folders
>are already replicating?
Thanks, guess that was an easy one. Not much dir..."Can't create the item" Solution
Hi everybody, just thought I'd share my experience with this (seemingly
very common) error message (with Outlook 2003)
Basically I was getting the error "Can't ceate the item" When clicking
a URL in any other application (IE, Excel etc), when Outlook was open.
Also I was getting the error message "Cannot start Microsoft Office
Outlook. Can't create the item" when Outlook was not open.
I noticed that the "Message" form was not listed in the Oulook
"Standard Forms Library". I had checked that the command line for the
URL:MailTo filetype was c...Import plain text with formulas into Excel
I'm having some trouble in Excel. If I create a plain text file like the
Nothing can be done as if in spanish is (SI), iserror is (ESERROR), and
so on. This really sucks as I can't just install other software on the
server nor make other modifications.
I don't know what Microsoft was thinking when they translated the
versions; any Excel version should accept it's language commands and
English commands, but well, that's too much to ask for...
Any good sugestions?