Special Pasting a work book with many sheets and formulas
I have a workbook with many sheets that all have formulas and links to other
data. I want to save the workbook as another name with all the worksheets
keeping the values only (no links or formulas). Is there a quick way to do
this for everysheet without having to special paste every sheet in the
workbook. So can I save everysheets data values at workbook level.
See this page for a code example
Regards Ron de Bruin
"lex63" <email@example.com> wrote in message news:ED708...Time Series
I have about 30000 lines of data that looks like so:
Where ColA is time. I am having trouble creating a graph with time on the
x-axis and count on the y-axis.
Thank you in advance.
You need to make an XY chart
But with 30,000 data points you could run into trouble; Help says you can
32,000 data points in a single data series.
However, if you want markers it will look like heck.
You could limit the data like this:
assume y-values in B2:B30001
in ...OWA. CA's. and Exchange 2007
The other day, I had to renew the Certificate on my Exchange 2007
server. Everything seemed to go alright, but eventually I received
complaints that outbound email wasn't being sent. Looking at EMC
showed all of the email queued up and waiting for something. After I
relaxed the settings on my router (Allowed all outbound SMTP instead
of restricting it to the Exchange server sending to MxLogic) all of
the outbound email went though.
I also was receiving reports of Webmail being broken (which was
halfway fixed with the help of
http://www.microsoft.com/technet/support/ee/transform.aspx?Pr...How to make Run Integration work in GP 10
Can anyone tell me how to make the Run Integration tool work in GP 10. We
just did our first client upgrade to GP 10 and the client has only 1
integration that they used to be able to run via the RUN INTEGRATION Tool.
Any help would be greatly appreciated.
I have the same probelm...did you get any answers to this?
I have to go into Integration Manager to run it b/c Tools>Run Integration
does nothing. I even checked the ini files to make sure the path is correct.
"Tammy Chavez" wrote:
> Can anyone tell me how to make the Run Integration tool work in...Multiple domains on one Exchange server / All but one domain shows up as spam #2
I am sorry if this is on the board somewhere but I have been searching
forever and havn't found a hint yet.
I have multiple domains setup on my exchange server. Lets say abc.com,
def.com, and hij.com. We only send email with @abc.com but can receive
from any domain name. Recently we merged with another company and we
brought back their email to our server, lets say xyz.com. Now I
configured a new recipient on Exchange 2003, so I now have two
policies. The first policy has the three original domains in it with
@abc.com as the primary domain. In the second policy I have configured
xyz.com t...VB Macro #2
I have a macro that is generating Excel files. When the macro runs, it saves
two different tabs in the workbooks as values. It needs to test and wait
until the formulas that are pulling amounts from another database are
correctly populated with the amounts.
Right now, I am getting N/A# instead of amounts for some, but not all, of
the files. I think the problem is that the formulas have not completed
pulling the amounts before the macro pastes that tab as zeros. (N/A# is what
appears when the formulas have not completed calculating - once they have
completed, the N/A# is replaced ...C# Adding Days to a Date
I have 2 objects:
objContract.activeon and objContract.expireson.
I am trying to add 364 days to objContract.activeon and assign it to the value
// Contract Start Date
DateTime dt = DateTime.Now;
objContract.activeon = new CrmDateTime();
int iFound = 0;
string sTemp = "";
if (objAccount.paymenttermscode.Value == 1) // due on receipt - use Todays
objContract.activeon = objInvoice.CFDinvoicedate;
else // ...VCR to DVD Part 2
Many thanks for previous answers.
Yes, finalizing the DVD worked
I found that DVD-R need finalizing but DVD+RW disks do not
But why was I able to play the unfinalized DVD-R on one machine and not on
What was special about the first PC?
Bernard Liengme wrote:
> Yes, finalizing the DVD worked
> I found that DVD-R need finalizing but DVD+RW disks do not
> But why was I able to play the unfinalized DVD-R on one machine and not on
> two others.
> What was special about the first PC?
Almost anything will play a finalised D...Separating Date and Time in a cell
I have a column of cells in the format "11/01/02 06:21". I would like to
separate the text into 2 cells - one with the date and the other with
the time. My attempts with LEFT and RIGHT have been unsuccesful. Thanks
for your help
Message posted from http://www.ExcelForum.com/
For the date use
replace A1 with the first cell of your range
you probably have to reformat the first to
mm/dd/yy (or whatever the setting is)
Note that you can do this by just using format but if you want to compare to
other cells with just pure d...Data migration - Adventure Works
I have a company where the adventure works db has been used and had a
lot of data populated into the system. We have now purchased MSCRM and
have obtained the company reg keys.
What is the easiest way to get the data from the 1 system to the next?
We will be establishing a new AD domain and users for the new
Data Migration Framework?
Microsoft CRM MVP
"funboy...set print area #2
Where is the "set print area" button in Excel 2002 that was in Excel '97?
> Where is the "set print area" button in Excel 2002 that was in Excel '97?
Are you sure it was "standard"? Only way I could get in was to right-click
the toolbar|Customise and drag it to the toolbar from Commands|File
...OEM publisher 2002 Sp1-2
I have the OEM version of Publisher 2002 and cannot find the Export as web page under File. Is there a way I can get that feature with a standalone disk?
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Chicagogal <firstname.lastname@example.org>...
> I have the OEM version of Publisher 2002 and cannot find the Export
> as web page under File. Is there a way I can get that feature with a
> standalone disk?
The OEM version of Publisher is exactly the same as the release in every way
but the license, so the standalone version will be no differen...GP SP#2 hangs with sa and Collections Issue
I just installed 8.0 SP#2 (ran the script that it says to run cuz we had
upgraded from previous version to remove dups in smartlist tables) and when I
log into GP as sa, it hangs and CPU sits at 100%.
When I was able to log in previously to SP#2, I constantly received errors
about the CN_Collector_MAIN table with invalid column names etc. I've
deleted the table, then re-ran the create tables, but it keeps coming back
with this error. I've even gone into file > maintenance > sql and deleted
and recreated the table, but then get "number of results doesn't match ...exclude administrator login to OWA ?
Is it possible to prevent the Domain Administrator account (which has a
mailbox) from being able to log on to OWA from outside ?
This would be meant as a security precaution.
Exch 2000, AD 2003.
On Wed, 14 Dec 2005 19:51:28 GMT, "JAQK" <email@example.com> wrote:
>Is it possible to prevent the Domain Administrator account (which has a
>mailbox) from being able to log on to OWA from outside ?
>This would be meant as a security precaution.
>Exch 2000, AD 2003.
In ADU&C on the Exchange server g...Run time error 5 : HQClient
When I double click HQ Client I have message box "Run time error 5 : Invalid
procedure call or argument"
how should I do? I used RMS 2.0
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 message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGr...Changing ip address of exchange server #2
I have a back-end server and a smtp server in DMZ.
I want to change ip address of back-end server. are there any issues?
all incoming and outgoing emails are going via smart host.
No issues at all as long as you remember to change all the references to
this server in your firewall, SMTP scanner etc.
"Jack Dorson" <JackDorson@discussions.microsoft.com> wrote in message
> I have a back-end server and a smtp server in DMZ.
> I want to change ip address of back-end server. are ...How can I print on 8 1/2"x17" paper?
I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
change the paper size to accept and print anything bigger than 14." any
suggestions would be greatly appreciated
First make the size settings in the Printer Setup. You may need to use the
"mickilena" <firstname.lastname@example.org> wrote in message
>I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
> change the paper size to accept a...Setting appointment start & end time increments format
In Outlook 2002, I can easily set the Day View to display
the time increments in 15 minute blocks, but on the
Appointments form, the Start and End Times available on
the drop-down menus, respectively, are in 30 minute
increment blocks only. How can I set the format for the
appointment page to have the Start and End Times for
appointments have increment time blocks of 15 minutes?
Thanks! My direct email address is:
If you set your appointments in 15 minute blocks
Outlook will start to offer that. It takes a few uses
Nikki Peterson [MVP ...when opening an excel file, 2 files open (one is book1)?
When I click on an excel file, 2 excel documents open up. One document is
called Book1 and the other document is the actual document that I want to
open. How do I stop this from happening?
To prevent Book1 from opening you can append /e to your shortcut for opening
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e
Alternative to the above............
Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.
If using WinXP OS you would scroll down to...Money Updates #2
Was wondering about money updates. What exactly is the program downloading
during the update process? And if the program is updated on a daily basis,
why would I ever need to upgrade to a newer version?
In microsoft.public.money, invalid wrote:
>Was wondering about money updates. What exactly is the program downloading
>during the update process? And if the program is updated on a daily basis,
>why would I ever need to upgrade to a newer version?
It is mainly changes in online bank setup.
Despite appearances is typically does not change anywhere daily.
"invalid" <...Can't create the item #2
I use Outlook from MS Office 2003 Business Edition.
Everything has worked fine until the past few days. Now,
whenever I click on an E-mail address link inside a
webpage, I get a message from Outlook that says "Can't
create the item."
One person on this group gave me the following advice:
>Close Outlook, find and rename the frmscache.dat to .old
I did searches on all my drives and the file named above
was not found. I doubled checked the search to confirm
that it included hidden files and system folders in the
search. Still no luck.
...Does POS 2.0 support price-embedded barcodes?
Does anyone know if Microsoft Point of Sale 2.0 supports price-embedded
barcodes (also known as random weight barcodes)?
I have Digi scales that print out 12-digit barcodes with UPC and price info.
I would like to implement POS and not RMS because it is much less complex.
Thanks for any info.
POS 2.0 does not support price-embedded barcodes.
> Does anyone know if Microsoft Point of Sale 2.0 supports price-embedded
> barcodes (also known as random weight barcodes)?
> I have Digi scales that print out 12-digit barcodes with UPC and price info.
&...how to know how many e-mail each user receives per day?
We are running Exchange 2003 on Windows 2003. I would like to know how to get
an average of how many e-mails each users send and receives per day.
...Time Format Question
I currently have time entered like this:
I need to look like this:
I've done a ton of research but nothing has worked so far.
With your values in column AA, try:
Gary''s Student - gsnu201003
> I currently have time entered like this:
> I need to look like this:
> 5:35 p.m.
> 9:02 a.m.
> I've done a ton of research but nothing has worked so fa...calendar for multiple time zone users: all day events
Users in different time zones post absences and meetings to a shared company
calendar. When an all day event is scheduled in one time zone, it shows as
spanning two days for other time zone users. How do we make this work
For the others it does intrude on a second day.
> Users in different time zones post absences and meetings to a shared company
> calendar. When an all day event is scheduled in one time zone, it shows as
> spanning two days for other time zone users. How do we make this work
Until you upgrade to Outlook...