I have a row of cells that calculate the totals for their columns but I
force to be blank via IF statements until certain conditions are met.
Once these conditions are met, the total appears. I'd like to also
highlight these total cells via conditional formatting. My conditional
formatting input is simply "If Cell is Greater than 0, format". For
some reason all the cells format as though they are all > 0 yet they
don't display anything. Are there some internal rules that specifiy
when a cell is really 0? Is there another way to do this that won't
care what the for...select all data with shorcut key
do u know a shorcut key to select all data, but not to create a table.
usually when i have thousands of rows and columns, if i want to select
all rows i must go to the end of the document and select with mouse
but isnt a fast and easy way to select all data?
If the data is contiguous and nothing else is touching it, you can use:
Lu�s Miguel Ramires Vieira Reis RAM wrote:
> do u know a shorcut key to select all data, but not to create a table.
> usually when i have thousa...Corrupt money data file
I've posted this on the Money UK site but with no reaction ; I wonder if I
can reach a larger audience on here - I'm desperate to sort this out, thanks.
On running Money, I received a message "Money has encountered a problem and
needs to close" - no indication of what the problem was. I couldn't get past
the splach screen
I found article 836197 in the knowledge base which seems to covers this ;
did what it advised, even to the extent of doing an uninstall and re-install,
but ...Analysing data from several excel workbooks
I'm totally new to excel and i need to analyse the changes in a funding
position across several years in a seperate excel sheet.
As in, submissions are made year on year showing the amount of revenue spent
on several different services. I need to be able to compare how those have
moved over the last 5 years in a single spreadsheet.
I appreciate any help.
To give a clear answer we would need a bit more detail of the data layout
Give us a simplified version of what the data looks like
Your 'subject' talks about different workBOOKS but the text of the ...recovering data
Money 2000: Is there a way to recover data that was not
backed up. I accidently deleted all deposits. When I
used the restore file procedure all saved deposits were
restored, but all deposits and withdrawals that hadn't
been backed up were deleted. How can I get that work
Retype it all? I mean, seriously, if you type three pages to a document in
Word that you last backed up a month ago, delete the three pages and then
quit Word where are you?
"ETHORN" <firstname.lastname@example.org> wrote in message
news:email@example.com...Managing Data Table
I need help to wrap the tex in Data Table. If any one knows how to do it,
please let me know. Thanks for your help in advance.
What version of PowerPoint are you using? What kind of table is it and how
did it get there (e.g. insert -> table, or a table connected with a graph)?
If it's a graph, is it an Excel graph or an MSGraph graph?
MOS Master Instructor
"Yogesh" <Yogesh@discussions.microsoft.com> wrote in message
news:F68FDA89-6289-4341-8886-54C580...Importing with Multiple delimiters
I am trying to import some very large flat files which use |~| as the
delimter. Does anyone know how to import this data into excel or
access? Or have VB code which will model importing and parsing this
large file. Starting with 30,000 to 600,000 lines in each text
file--only need 3-10 items in the whole....
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
This is very easy to do, not in EXCEL, but ACCESS. Create
a new database. When you see the new database windo...Import 10-03-03
I am having a problem importing leads. I have a simple
lead file: Topic, Fname, & Lname. it is a CSV file. When
I try to import, I get a system error in IE. I've
imported leads before without a problem. The only thing
that has changed is the addtion of 1 custom field in the
lead form. I don't have access to customersource because
we got the software for free at a seminar on CRM. Any
help would be appreciated.
what is the error kevin?
also when you added the custom field to the form etc i assume you published
the change through deployment manager and res...Importing data #5
I have a workbook in Excel 2003 that I need some advice on please. The data
used in the spreadsheet is collected online into a CSV file, this CSV file
is imported into Excel onto a "Raw Data" worksheet. From this raw data
several other worksheets need to access this raw data to prepare the reports
required. I have the first report sheet designed and it picks up the data
from the Raw Data sheet. The problem I need help with is updating the raw
data; when I download a new file from our web site and refresh the data
import the report worksheet does not update correctly. Fo...Append Query
I have a table "Rates" with the following data:
StartDate: 5/15/08 End Date: 6/23/08 Rate: $53
StartDate: 6/24/08 End Date: 7/15/08 Rate: $86
StartDate: 7/16/08 EndDate: 9/19/08 Rate: $99
I have another table "Transactions". I want to create an append query such
that if I supply the StartDate and EndDate, the query will populate the
"Transactons" table with date and rate data from the "Rates" table for each
and every day within the date range. Example: If I supply the StartDate of
6/23/08 and the EndDate of 6/25/08, the query would pop...Outlook 2007 error when closing
Why am I getting this error when closing Outlook 2007.
"Microsoft Office Outlook has encountered a problem and needs to close. We
are sorry for the inconvenience" and it shows a check box "Restart Microsoft
I'm getting below details when clicking "What data does this error report
Appname:outlook.exe Appver: 12.0.6514.5000 AppStamp: 4a89dc70
Modulename: dccmsp32.dll ModVer: 10.0.2009.929 ModStamp: 39d4133c
fDebug: 0 Offset: 00005346
Thanks in ad...Quicken Import #2
I've been using Quicken for about 10 years. I have all my checking,
investment, retirement and loan accounts in Quicken. I have never used MS
Money. I am considering buying MS Money 2004 Deluxe. My questions are: (1)
When importing from Quicken into Money, how accurate will the data and
accounts come across? (2) How does Money compare with Quicken? (3) When
importing into Money, do I use an import function and/or restore? I have a
considerable amount of data in Quicken and I would hate to edit data in the
Money accounts to agree with my Quicken accounts.
In microsoft.pub...How to combine/consolidate data
I am about to create an Excel file that should be used by custmers to place orders. On the first sheet, I would like to have a summary of the entire order, so the customer can see what he ordered.
All data is organized in same sort of tables accross several sheets - each sheet representing different product group.
So, lets say I have table organized like below:
ColumnA ColumnB ColumnC
Product Price Order
Prod1 10 1
Prod3 20 2
And I have several of such tables on different sheets corresponding to each prodcut category.
Now, on the first sheet, I w...Traspose Column data into Row
I want to transpose column data in to row. I have seen many posts (using
INDEX or OFFSET functions) but all these solution assume a fixed block of
data to be transposed, My problem is that the data i have not only has
variable blocks to be transposed but also has some duplicate
headings(headings are duplicate but the data in front of each heading has
different value. Below is the example of data
Col A Col B Col C
PRODUCT COST COMPONENT COST$
A Raw Mat 10
A D L ...rapid migration tool error
when i use the rapid migration tool to move data from quickbooks 2006 to
dynamics gp 10, I get this message: no mapping between account names and
security id's was done. How do i fix this??
How do you cut and past photos into Publisher 2003 without them coming in
huge rather than the original size? This is an irritating feature that was
not present in Publisher 2000.
You sure you know the original size? They go on the document page "as is".
Thereafter you can resize it on the page.
David Bartosik - [MSFT MVP]
> How do you cut and past photos into Publisher 2003 without them coming in
> huge rather than the original size? This is an irritating feature that was
> not...how to create row with data
imagine i have two rows: name and color:
what i want is having, in another row, just the names that have blue eyes,
On Mon, 11 May 2009 17:26:04 -0700, rafael
>imagine i have two rows: name and color:
>what i want is having, in another row, just the names that have blue eyes,
i have excel 2000
what i want is all names in a single row, wi...data import and word templates missing from CRM
Hi. I'm working with a new install of CRM and there are some icons
missing in the setttings area such as the import function on the data
management page and word templates under templates. Any ideas about
why this is?
...Toolbar button error?
In Excel 2003 I put a button on a custom toolbar - the button is the 'double
bottom border' and is from the Customise-Format selection of buttons.
However this button just gives me a single bottom border. I can get double
borders in other ways, e.g. from the drop-down borders box, where the
identical-looking button does give me a double bottom border.
Is this an error, or am I missing something?
does the same for me too ... so i think it's broken :(
and while this is no help at all to you i'll say it anyway ...Excel to publisher import
How can I import an excel spreadsheet to publisher doc.?
If you want to insert the actual spreadsheet, you can go to Insert > Object
> Create from file and browse to the Excel file.
If you want to merge the contents of the cells, you can use the Mail Merge
feature in Publisher.
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
"Bill" <Bill@discussions.microsoft.com> wrote in message
> How can I imp...visual c++ runtime errors
In many applications when I get a crash it simply creates the drwatsons log
file and displays that it has crashed. Sometimes however I get a visual c++
runtime error and they never write out to the watsons log file.
Unfortunately its a multithreaded application so almost impossible to track
down what is causing the problem without some type of debug log or dump to
tell me where it crashed.
Is there someway to disable to the visual c++ runtime error box so it can
just crash happily? lol
...Question with local vs. remote (Exchange server) data
Can someone please explain something basic to me about the way Outlook
works. I'm a Mac user and not familiar with this thing but now need to
figure out how to synchronize it with a PocketPC PDA device.
We've got Outlook on our PCs (W2K), connected to an Exchange server. So,
I see my calendar and contacts, which I know live on the server. But when I
sync my device, it ends up empty. Is there some sort of "local" (to my PC)
data that it's using instead of the Exchange server's info? If so, where is
it and how do I find it? If I could find it, I could copy the Exchan...Invalid response (0x800ccc60) error in microsoft outlook
I am geeting "Invalid response (0x800ccc60) error in
microsoft outlook" when I send the mails.
Can any one help me why this error occurs.
How to solve it?
Thanks in advance
Have you verified the SMTP address is correct or not the
error you have reffered is a SMTP erro.
>I am geeting "Invalid response (0x800ccc60) error in
>microsoft outlook" when I send the mails.
>Can any one help me why this error occurs.
>How to solve it?
>Thanks in advance
>...Bytes in Data Page Row
I am reading a book titled "Microsoft SQL Server 2008 Internals". In Chapter
6, which was authored by Kalen Delaney, Kimberly Tripp, and Paul Randall, the
following table and Clustered Index is created:
CREATE TABLE Employee(
EmployeeID INT NOT NULL IDENTITY,
LastName NCHAR(30) NOT NULL,
FirstName NCHAR(29) NOT NULL,
MiddleInitial NCHAR(1) NULL,
SSN CHAR(11) NOT NULL,
OtherColumns CHAR(258) NOT NULL DEFAULT 'Junk')
ALTER TABLE Employee
ADD CONSTRAINT EmployeePK
PRIMARY KEY CLUSTERED (EmployeeID)
It states on page 321 of the aforementione...Invalid Add-in error message
When I open Outlook 2003, I keep getting the following error message:
C:\Documents and Settings\Amanda\Application
Data\Microsoft\AddIns\outlvba.dll is not a valid Office Add-in. Then I am
booted from Outlook. How can I fix this?
Try renaming outlvba.dll to outlvba.bak. Go to the add/remove applet in the
control panel and perform a detect and repair on Office/Outlook 2003.
ps - outlvba.dll normally exists at \Program Files\Microsoft
Office\OFFICE11\ADDINS. I've never seen it under a user profile.
"urbangirl" <firstname.lastname@example.org> wrote in me...