Project Server 2007 Implemenation costs
I want to implement Project Server for web access to 50 users.
We already have MS Project 2007 installed on all PC's running XP operating
I know I will need a Project Server License and 50 CAL, but what other costs
You'll need to make sure your Project version is Project 2007 Professional.
In addition to a Windows Server, you'll also need SQL Server and the relevant
SQL CALS, one CAL for each Pro user AND each web user.
> I...macros in excel #4
Is it possible to set up a macro in excel to print report with conditions
> Is it possible to set up a macro in excel to print report with conditions
Can you elaborate on "Conditions" and what kind of report it is? May be I
can pitch in .. I am a beginner too, but I can look around.
I am trying to set up a report from database of vendors. Each vendor has it's
own number. Some vendors are grouped together. In report, there should be
list of each vendors and all grouped vedors should have subtotal for its
data. I know it's easy to do a subt...export excel macros
I am gettting a new computer from my IT staff this week. Is there a way to
backup all my personal macros. I have done a search for personal.xls and
have not come up with anything. Can anyone provide answers.
search for your personal.xls in your xlstart folder
> I am gettting a new computer from my IT staff this week. Is there a
> way to backup all my personal macros. I have done a search for
> personal.xls and have not come up with anything. Can anyone provide
&...Chart wizard funcitonality in Excel 2007?
I hope I'm missing something in Excel 2007. In Excel 2003, the chart wizard
gives you access to lots of options when you create a graph--graph type, data
range, the various series (including the X axis labels), the chart title and
axis titles, gridlines, legends, and others. It doesn't take long to create
the graph with most of the options you want and then tweak it pretty quickly.
In Excel 2007, it seems that every option is a separate button/menu/choice.
Setting the chart title, the x-axis title, and the y-axis title are three
different operations. Ditto for pretty much everyt...Excel Database
I'm developing a database in Excel and I need some help with macros.
It's a database of drink short takes for a bar. Each tab has a different
summary category, such as spirits, wines, cocktails, etc... Cells in each
summary tab links to a new tab, where the data for that entry is explained
(the short take sheets themselves).
Short take planner
Now, imagine a simple monthly calendar, each cell corresponding to each day
of the month that has a drop down list of values to choose from.
First, I would like to make this drop down list show data from the...Preserving Cell Formats in Excel Query
I am doing queries on a large workbook of multiple Excel spreadsheets. When I query the data, the original data formats don't carry through to the query results. Is there a way to carry original formatting through to Excel Query results
Any insight would be appreciated
No, you can import the data, but not the formats. If you're importing
programmatically, you could apply the formatting as part of the import
Karen S wrote:
> I am doing queries on a large workbook of multiple Excel spreadsheets. When I query the data, the original data formats don't car...Hidden data when pasting from html page into Excel?
I have a situation where I copy a report, which is generated as an html page,
into Excel for analysis. When a new copy/version of the report is available,
I copy and paste the new data over top of the old in Excel.
I've noticed that the size of my Excel file is growing after each copy/paste
situation. To manage this, I can delete the worksheet where I paste the data
and reconstruct it. After doing nothing else, saving the workbook results in
an immediate reduction of file size. If I simply select everything on the
sheet and delete, the file size does NOT go down; I have to delet...divide so no error Excel 2007
I have a simple issue. I have two cells with numbers and I want to divide
one by the other and set it up on many cells. Problem is if I enter the
folmula befor there are actually numbers in the two cells I get the Divide
by 0 error (#DIV/0!)
So How can I divide A2 / B2 only if it won't produce an error?
"Striker" <firstname.lastname@example.org> wrote in message
>I have a simple issue. I have two cells with numbers and I want to divide
>one by the other and set it up ...Historical Excel question re: statistical capabilities
Does anyone know approximately when Excel started shipping with
statistical functions built in- or know how I can find out?
In the pre-spreadsheet days of my computing past, I used BASIC to code
statistical functions necessary for my profession. As spreadsheets
became more advanced, we all transitioned to using the advanced
functionality. My question is when did this occur? Did Excel always
have its current complement of statistical functions?
email@example.com shared this with us in
> Does anyone know approximately when Excel started shipping...Formula result shows as zero Excel 2003
Formula as shown =IF(C12<>"",+C11-C12,"") appears in D12. This is the same
formula as rows above but rows above show correct result whereas D12 and
subsequent rows show only zero.
If I do an F2 and F9, the correct result shows in the Formula Editing bar so
formula is working correctly. I have tried copying both formula and cell
formatting from previous rows which do display their result correctly but
still doesn't fix the problem.
Any assistance would be much appreciated
maybe automatic calculation is disabled. Check 'Tools - Options -
Calculate...Money 2007 fails additional update
I am trying to use Money 2007 Premium on my new computer (Windows XP SP2) and
it installs fine, but when I start Money it notifies me that an additional
update is required. It looks like it downloads the files properly but fails
the add'l install. I have tried the following:
uninstall and install again
turn off all virus protection (Panda) firewalls, etc.
download directly from the web
None of these have helped.
I saw one article on this problem that said to remove a Core File, but I can
not find it on my computer.
In microsoft.public.money, Josie wrote...Outlook 2007 add-on
Wonder is there any outlook 2007 add-on that can show related email
messages (even if exchanged between 2, 3 or more persons), based on
the similarity of emails' contents?
I know Outlook 2007 has the option to arrange columns per
"conversation" but if 2 messages have same content with different
subjects, they are not included in the "conversation" display..
Any ideas here?
Thanks in advance!
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal ...Cusotm Office 2007 install for English, Spanish, & Chinese users
Hi, I'm working on creating a custom install of Office 2007 for my various
sites. These sites include users that speak English, Spanish and Chinese. I
am a bit confused on how to use language packs in order to provide
multi-lingual support. From my understanding, I need to download the Spanish
and Chinese language pack and place the .msp files in the Updates folder on
my network install point? Does this mean when office gets installed on a
Chinese computer it will be in Chinese automatically? Or does the user need
to "flip a switch" to make it Chinese language? The ...How do I add a total to a stacked bar graph in Excel
I am using Excel for some graphs in Powerpoint and we are using stacked bar
graphs. Does anyone know how to add a total on a stcaked graph? I can add
individual values but I am looking for total per bar.
the simplest way is to copy the data with the totals into the chart.
select the section of the bar equal to the totals and change the axis to
add the series values and in paterns select none for fill and line. in th
elegehgend select the line for the totals and clar all.
"Greg L" wrote:
> I am using Excel for some graphs in Powerpoint and we are using stacked bar...opening excel worksheet
Operating System: Mac OS X 10.6 (Snow Leopard)
whenever I try to open an existing excel worksheet it opens very short. I have to drag it down to the bottom of the screen, is there a setting that i need to adjust?
No, simply SAVE the workbook after you adjust it.
Next time, it will open at the size you want.
On 27/03/10 6:42 AM, in article 59bb6065.-1@webcrossing.JaKIaxP2ac0,
"firstname.lastname@example.org" <email@example.com> wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
> wh...backup same set of servers from 2 DPM 2007 servers
I am changing the DPM server 2007. However, I would like to take this
opportunity to revise all protection groups so that I can restore bare-metal
any server from a single lTO-4 tape if possible.
During this "transitional period," I would like to leave the existing backup
settings on the older DPM server to continue to run while adding jobs to the
new DPM server.
Looks like to me that I have to re-install the agent on all servers so that
they can be recognized by the new DPM server. IS there a better way to do
this if my plan is possible at all?
...Using Queries in Excel
What are the best practices for using database-like queries in Excel.
Let's say you wish to join to sheets together och view a subset of
columns in a third sheet.
I've tried several different methods, but I dont think any of them are
completely good. I've used VLookup, Index, MS Query. (MS Query must be
the must forgotten MS product in history. It's like a time machine
back to Windows 3.11)
I've also tried alot of different methods for searching a range, based
on more than one criteria, and display the result, either a single
value or a sum based on several rows. Here i...Downloading process for Office Standard 2007 online
I experienced a severe computer failure and when it was repaired, I lost my
installed programs. I need to get back on Outlook and Word, but only have the
program key for the Office Standard 2007 program. How do I get to the screen
where I can input my program key to get the process started?
You need the Office installation cd in order to reinstall
"Jack" <Clear@view.com> wrote in message
>I experienced a severe computer failure and when it was repaired, I lost my
> installed programs. I need to get...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?
---------------------------------...cannot filter excel files in "files of type"
I have Outlook 2003, and when I try to add an attachment, I cannot filter
based on Excel files in "Files of type". Excel is the listed but other like
Word are. The entire Office 2003 suite is installed on the PC and I tried
reinstalling to no avail.
Also, Customize is grayed-out under the tools menu in Outlook\new mail
Please help me out.
Sorry, I mean to say Excel is NOT listed under "Files of Type"
> I have Outlook 2003, and when I try to add an attachment, I cannot filter
> based on Excel files in "Files ...Using tables created in 2003 IN 2007
My office has recently upgraded to 2007. I enjoy new features such as the
ability to highlight a few words within the table without the ENTIRE table's
font changing; unfortunately, this only works in tables I have created since
the upgrade. My old tables that were brought over from 2003 do not have this
capability. Is there an add-on out there? I do not have to resort to
re-typing and creating all new tables. PS. Copy and pasting into a new table
does not work. Convertting the file using the office button does not work.
I think you talking about what is called...excel error "no more new fonts..."
Using Excel 2002. Pretty large sheet with about 60 tables.
refuses to copy and paste a table.
Getting error message "no more new fonts may be added to this workbook"
cannot find anything anywhere on this error.
...Formatting hyperlinks in an Excel cell 02-16-10
Two of the columns in a spreadsheet (Excel 2003) that I use record email and
All of them appear as hyperlinks i.e. blue and underlined but some
occasionally seem to lose their hyperlink properties. This means that when
one hovers over them, the cursor stays as the usual Excel cross rather than
changing to the hand/finger symbol. Also, clicking on the former does not
launch the browser.
Is there any way to ensure they are formatted, and work, as hyperlinks
...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 ...Parse multiple text lines into 1 line in excel
help. I am an excel beginner and can't find out how to turn multipl
lines of text into 1 row in excel. It's probably really easy but m
manual is USELESS. Can anyone help
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
You're a little short on details. If nothing below fits the bill post back.
"Multiple lines" is how many and is each line in a separate cell down one
Do you want all lines to go into one cell?
You can use this form...