Error Checking Excel 2002
Is there a way to permanently turn off the Error Checking
and make Excel 2002 run like 2000? I am tired of having
to "convert text to numbers" when I copy/paste from
another source. Excel 2000 and prior always recognized a
number as a number. When you have a large amount of data
you're working with, this can be a pain. I do know you
can use VBA, but you can't always distribute that to all
Tools>options>error checking, there you can remove the checkmarks you don't
I also remove thing like show paste options button and show insert options
butt...How do I change a default Message Delivery option?
I have a user who has managed to change his default email option to have
"Expires after" turned on by default. I would like it turned off. I've
tried turning it off and saving it as a template, but I would like it off in
the default case...
...Change Old Meeting Requests?
We've got a situation where a year or ago or so we moved from Exchange 5.5 to
Exchange 2003. This change was accompanied by a domain change. The move
went fine, but were are now finding that people who had reoccurring
appointments on their calendars are getting error messages if they try to
change them. These "meetings" are really just maintenance reminds and the
like, they they don't occur very often. But if someone tries to do something
that results in an e-mail being sent the message send fails. For example, if
someone tries to change a staus from tenative to a...Excel web template
When using the option to save an excel file with multiple sheets, I elect to
"save as a webpage". Works great and looks good with some formatting editing
in the file. But I am curious, when "saving to a webpage", is there a way to
get Excel to use a template file? For instance, a webpage already setup with
the background color and other things. Seems like it should be able to get
done, but I could not find anything! Thanks much.
Mark: I believe that would require some VBA. The only alternative I can
think of, but did not test... Save Excel as HTML, then open that html ...OWA Change Password #2
I have Exchange 2003 SP1 in a Windows 2003 AD domain. OWA works great with
SSL. I have enabled the Change Password button in the Options page. I have
created the Iisadmpwd virtual directory, ... basically followed these
I see the button, click on it, the popup window appears (but first I have to
log in again - cause I have only Basic Authentication turned on on that
virtual directory). After I fill it out, trying to change the pass...How do i invert text in Excel
I have a row with a text string in it and I want to INVERT it, so that it
appears upside down. Is there any way to do this in Excel or is this more of
a graphic manipulation limited to Word or Visio?
AFAIK you can only rotate cell text 90 degrees in either direction.
"Eladb" <Eladb@discussions.microsoft.com> wrote in message
>I have a row with a text string in it and I want to INVERT it, so that it
> appears upside down. Is there any way to do this...Template Wizard with Data Tracking
I have been using this add-in just fine for about a year,
gathering data from about 20 users onto an Excel Database
by having them all use the template. But I recently made
some changes and then began having the following
problem: After a worksheet has been created using the
template, and saved as a new record in the database, and
then we want to go back in to change the record and
update it in the database, the option does not appear to
update the database; the only options continue to be to
create a new record or to proceed without saving to the
database. It is as though the sys...Upgrade DB version from SQL Server 2000 to SQL Server 2005
Hi, I have a deployment with GP 9.0 SP3 with SQL Server 2000. I want to
upgrade de Database engine to SQL Server 2005 in order to use SQL Server
Analysis Services, SQL Server Integration Services and SQL Server Reporting
What can I do to accomplish this DB Upgrade? Do anyone have the formal set
of steps to execute?
Please help me!!!!!!
I am sure others will have more suggestions for you, but here is what I
recommend for a smooth upgrade to SQL Server 2005 from SQL Server 2000.
1) Make sure you have all your database backups in place
2) Install the SQL Server 2005 Upgrade Ad...Change AND to OR
Like change the criterion of search of AND to OR in the filters of the CRM?
no way to do this,.....either create your own app or purchase one from an
"Eduardo Testa" <firstname.lastname@example.org> wrote in message
> Like change the criterion of search of AND to OR in the filters of the
...Time Stamp-With Change
I seen many posts on in this forum on time stamps. My problem this tha
in a1:a10 are going to be the entries. I need upon each entry into eac
cell a time stamp in b1:b10, but I need this to be hard coded so that i
I went back in a1and made a change it wouldn't change the time again i
AntonyY's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1669
View this thread: http://www.excelforum.com/showthread.php?threadid=32046
Try this in a worksheet module....Change Payee Name for an Epay
Is it possible to change the name of an epay payee? My example is, my credit
card company was BankOne. It has changed to Chase. Same account number, same
mailing address, same everything except the name. I can't find any way to just
change the name to Chase and keep the history.
It's not directly possible.
If it's important to you, I would:
1. Disable online services.
2. Create a new payee called Chase.
3. Move the BankOne payee to Chase (Right click on BankOne in the payees
place & select move).
4. Enable online services.
"Tommy Flynn" &...Message Tracking #6
What is the best way to check if your exchange sometimes doesn't accepts
mail (delay) or doesn't send mails correctly (delay) Message Tracking ?
But how do you actually do this
"Guillaume Coign�" <email@example.com> wrote:
>What is the best way to check if your exchange sometimes doesn't accepts
>mail (delay) or doesn't send mails correctly (delay) Message Tracking ?
>But how do you actually do this
Assuming you're asking about messages leaving your organization, the
SMTP protocol logs are the place to ...Color Changes
Have inserted company logo in publisher file. It is in
eps format and looks/prints fine from illustrator but
will not look/print in the right color from publisher?
Can I fix this?
Whilst attempting to develop brick-based storage technology, Ed reads a
message from Becky N <firstname.lastname@example.org>
> Have inserted company logo in publisher file. It is in
> eps format and looks/prints fine from illustrator but
> will not look/print in the right color from publisher?
Make sure you are using a PostScript printer (or using a PDF file as an
Ed Bennett - MVP Micr...Track Changes compatibility between versions of Excel
I'm planning to undertake a project which involves Excel sheets
created in Excel 2003 and tracking the changes made to those sheets
via Excel 97. Does anybody know of any problems with the compatibility
of this function? This would help me out a lot. Thanks.
...How do I track half days in the attendance tracking template?
I've just created an attendance tracking template in Excel, however realized
that there isn't an option to track half or quarter days taken off.
Does anyone have any suggestions?
A lot depends on how you've laid out the data. Instead of tracking
whole days, can you track hours? 8 for a full day, 4 for a half day,
...Tracking GST/VAT in MSMoney Standard
I'm new to Money & processing small business accounts. Had no problems
tracking & reporting VAT in Quicken & havegot Money to calculate VAT with
each relevant entry. Somehow just not finding a report that shows VAT
totals, taxable income etc. Please HELP!!!!!
...I want to email only 1 page of my excel sheet how do I do that
I have an excel sheet that has three pages to it. I want to be able to email
only one of the pages to a client. Is there any way I can do that?
You can send the selection or range Maureen
See my site for a example
Regards Ron de Bruin
"Maureen" <Maureen@discussions.microsoft.com> wrote in message news:EB8883BB-90FB-424D-AC6A-D7899C1C5F96@microsoft.com...
>I have an excel sheet that has three pages to it. I want to be able to email
> only one of the pages to a client. Is there any way I can do that? ...isa owa exchange2003 changing port?
is it possible to work with other port than 80 or 443?
what should i configure in isa?
"shamunmic" <email@example.com> wrote in news:ONWlypkwDHA.3144
> is it possible to work with other port than 80 or 443?
> what should i configure in isa?
I believe if you change the port of OWA it becomes an unsupported
FAQ located at http://www.swinc.com/resource/exchange.htm
Newsgroup archives at http://groups.google.com
...Hex value change from o to �
I have load Cobol flat file into sql table by bulk insert.
There a packed comp-3 filed. I am trying to convert to Hex decimal.
The flat file was like 'o' o = 9c in hex.
after bulk insert into sql table the value became '�' the last char � =
3a in hex.
any ideas why the last char changed after bulk insert?
Mecn (firstname.lastname@example.org) writes:
> I have load Cobol flat file into sql table by bulk insert.
> There a packed comp-3 filed. I am trying to convert to Hex decimal.
> The flat file was like 'o' o = 9c in hex.
&g...Excel startup with buttons
I was wondering if it is possible to have a blank screen displayed when
a user opens up excel, and have them select a button to take them to a
particular worksheet in the excel workbook.
I have figured out how to use code in visual basic to create the
buttons, but when I open the workbook, it displays the "button screen"
overtop of whatever the last page was when the workbook was last used.
I'd rather not have any of the worksheets visible behind the button
a...PO Receive should let me change price before commit
When receiving a PO and changing the price using 'New Price' column and
receiving some or all items and then printing labels the old price is printed
on the labels. I do not want to 'Commit' first because I need to use
'Issued/Received on this order' bullet in label printing because I may have
received on this order before and may be receiving more in the future.Thanks
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
Agree" button in the m...HTML Table pasted to Excel
I have to copy a table out of a web page and paste into excel and then add
formulas to the spreadsheet.
When I try to sum a column of figures, I get a "0" result because the
numbers have a "$" before the number and a space after the number.
Is there any way to either sum them as they are, or remove the $ and space
in all the cells?
Example (each cell has a space after the last number):
One way, assuming your data is in column A, enter this formula in B1
Copy down the column
Roger Govie...Outlook 2000: Any way to track Calendar access
I've opened up my Calendar for anyone to read in Outlook 2000. Is there any
way to track who accesses it?
...How to track meetings for a task?
How would you suggest to charge meeting time to a my Timesheet task? TIA!
Depends on if it's a planned meeting or informal. I typically just create
a bucket task through the entire schedule for "Meetings" or book it to PM
time. You may also opt to create a distinct line item bucket task for status
meetings as opposed to other ad hoc meetings.
If it's a big phase gate meeting, I may list that specifically as a line
item, but for anything less than that, it becomes too granular for effective
- Andrew Lavinsky
Blog: http://blogs.catapultsystems...track Shipment
Is it possible to set up the Track Shipment so when you click on TRACK it is
automatically bring up a browser with the tracking information?
For UPS what will be the URL to set up?