Mail merge with Excel in Publisher 200
Whenever I open a merged document in Publisher with I merged with an Excel
spreadsheet, I must re-establish my link with the spreadsheet (including any
filters I originally set)--quite annoying.
This is has not always been the case; I have some connections which have
stayed connected. These could possibly be ones I did in an earlier version
Is this a problem with just Publisher 2000 or is there a way to permanently
connect my publisher document with my Excel spreadsheet?
...How do I insert Roman Numerals?
New to Word 2007 would someone please explain to me how to insert Roman
Numerlas in my document?
"ckj" <email@example.com> wrote in message
> New to Word 2007 would someone please explain to me how to insert Roman
> Numerlas in my document?
Just type them...
Type a number e.g. 21, select it and run the following macro
Dim oRng As Range
Set oRng = Selection.Range
oRng.Fields.Add oRng, 34, oRng.Text & " \*Roman"...Problem while converting excel to csv for Special Characters
I need to convert excel sheet data into csv format data=20
file, but while doing so for some Eastern countries, like=20
Poland, special characters in the excel sheet are getting=20
converted into junk data
Excel Sheet Original line - Zesp=F3l Opieki Zdrowotnej w=20
Line when converted to CSV - Zesp=F3? Opieki Zdrowotnej w B?
Really appreciate your response on this.
I'm not sure if this will help, but I just copied your first original line into
a excel worksheet (USA xl2002) and saved it as .csv.
I re-imported and it looked fine.
I opened t...Not plot a data series in a chart but still display in data table
MS Excel 2007
I've somehow managed to display only two data series on my line chart. They
still display in the data table. How did this happen? More importantly, how
do I reverse it. I don't want to recreate chart.
I see the data series not plotted on chart in the Chart Elements and when I
select the series, the source data is highlighted; it's in the data table.
How do I make it visible?
HAve you perhaps simply formatted the data series as "no line, no marker"?
If so, you can format series, add some color.
Looking for some advice on SQL 2005. I have a table that will usually be
populated by an SSIS package. I want to set the "loaddate" column to the
current time after a record is inserted. Should i do this via trigger or
should i just build a step in the SSIS package to update the column after the
If trigger is the way to go, what is the syntax to create the after insert
Thanks in advance.
You can create a default constraint on the table set to CURRENT_TIMESTAMP. That will handle the automatic date
assignment without any need for coding.
-...Automatioc spill over data to a new Excel sheet from Xml source?
I have an XML source file with data for more than 256 columns. Since one
sheet can contain a max of 256 cols, Is there a way to make Excel, create an
additional sheet to keep the excess data? Preferrably using Xml map /
...How do I prevent duplicate entry of a sku in a data table?
I want to keep folks from entering the same sku into a table (i.e. like data
validation does for other parameters).
Assume that you want to restrict the users from typing the duplicate values
in A Column.
Place the cursor in A1 cell and press Cntrl+Spacebar which will selecte the
A Column. Keep in mind that the active cell should be A1 cell. (Active cell
will have a white background after selection also)
Data >>Validation>>Settings>>Validation Criteria>>Allow>>Custom>> and in
Formula paste this =COUNTIF(A:A,A1)=1
Data>>Validatio...How to retrieve data which contain "/" in it
I try to pull a data from access with contain a speacial character "/" in it
but what i get is it not return a single data, so how do i wanna retrieve it?
below is statement I use it but it return nothing.
SELECT LDDATA.COR, LDDATA.CON, LDDATA.PCODE, LDDATA.QTY, LDDATA.BOXNO,
LDDATA.CASENO, LDDATA.RSNOS, LDDATA.RSNOE, LDDATA.NOFRS
FROM LDDATA WHERE (((LDDATA.COR)="A11/LC/000002/11/06")) ORDER BY
On Tue, 22 May 2007 21:53:02 -0700, osmanar
>I try to pull a data from access with...How do I get only the data I want to be shown?
I have approximately 2000 rows of data all with strange data in it. Each row
starts with positions of stars in sexagesimal format. I want to filter
through these so that I only have the ones I want (approx. 600), followed by
the data in the row that corresponds to the position. I have the list of the
ones I want in a seperate column (i.e. there positions). How do I get them?
I hope this makes sense. Thanks!
Two approaches come to mind.
1) Use an advanced filter. Click in the larger table and select Data >
Filter > Advanced Filter. The 'database' should be the larger t...Excel Re-Calc causes network traffic and very slow response times.
Excel Ver 2003 SP2
Windows XP SP2
Microsoft SBS Server 2003
Workstations: P4 2Ghz, 512 Mb Ram
I have an excel file with hundreds of vlookup and indirect formulas. It
has no links to any other spreadsheets. The file resides on a shared
network drive on our server. When users do a recalc or change a number
in the file causing a recalc it takes about 7 seconds... however after
a bit of experimentation I find that if we open the file and then
disconnect the workstations network cable the recalc takes less than
one second !
Tried saving the file to the local drive of a workstati...Need list of the different versions of Excel
In the past my first version of Excel was Version 5, now I use Version 8
I would like to know the names (Version numbers) of all the Excels, starting
with the first one.
I am working on a project that I intend to offer for sale to the public.
Therefore, want to know which versions it will work on. Maybe it will on
some prior versions depending on what features are used.
Microsoft MVP - Excel
"Ed" <Ed@discussions.microsoft.com> wrote in message
when i opening excel application, excel with opening as default sheet2
page.whereas the default sheet1 should be open.please suggest.
You may have another instance of Excel open, which has already used
"Sheet1". The next available name is "Sheet2".
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Thiyagu" <Thiyagu@discussions.microsoft.com> wrote in message
> when i opening excel application, exc...Grouping Data
I have a subform that shows a usual set of data such as:
The client wants me to be able to do the following:
I.e. merging data cells where they are the same value
Preferably with Name1 being centered across the products. Within a
straight access form I would use a group via crosstab however this is
an access adp on SQL Server.
Can anyone help?
In a report you can hide duplicates.
Build a little - Test a little
"BecksWatkinson@gmail.com...inserting hrs and minutes
I have a cell in my time card that displays total weekly time -ex-
"40:15" is there a way to make it more like this...40hrs,15mins
Message posted from http://www.ExcelForum.com
Use a custom format hh"hrs",mm"mins"
"-Brian-H- >" <<Brian-Hfirstname.lastname@example.org> wrote in message
> I have a cell in my time card that displays total weekly time -ex-
> "40:15" is there a way to make it more like this...40hrs,15mins ?
> ...insert an interactive excel file into word web page
I'm trying to insert a excel file into a word document with text, and then
save it was as a web page, but I want to keep the excel part interactive.
...Recolor embeded Excel graph in PowerPoint
Is there any way to recolor an embeded Excel graph colors
to match the color scheme of targeted PowerPoint file?
You could create a user-defined custom chart type with the colour schem
of the presentation and apply it to the embedded chart.
I am not aware of any in-built color synchronization between powerpoin
and excel, though.
Message posted from http://www.ExcelForum.com
when you say "A user-defined custom chart type"
Is this "Chart>Chart type>Custom types>User-defined" ?
1. Create the same type of graph with MS Graph.
2. Add...Insert | File > Attachmnet-Button Drop Down ;What is the difference between Insert and Insert As Attachmnet
re: "Outlook2003, File-Insert-Options"
On making new-email with Attachment-File(s),
File Menu | Insert | File >>> (Brows and select File to insert )
then we can see the button "Insert", and write side
Drop Down Arrow lower-right side of Dialog Box;
If it clicked,
we can see three options as follows:
Insert as text
Insert as Attachment
I can not recognize/understand the difference
between "Insert" and "Insert as Attachment"
What is the difference between Insert and Insert As Attachment ?
I would appreciate y...Inserting Hyperlinks in a Protected Sheet
I run Excel 2000 and I have a protected worksheet that I share wit
users in my organisation. I want to allow the insertion of a hyperlin
to a specific file type within a specified directory on our server.
1.Protection on disables the insert hyperlink command. Can this b
overcome with worksheet activate code?
2.Can I limit the types of files (preferably by requiring the file t
meet a mask format eg "z-*.xls")?
3.Can I limit the directory that can be linked, by referring to
pathname stored in a cell on the active sheet?
Would appreciate your suggestions.
Thanks S...Exporting Excel Charts in Separate Tabs
I have an excel file with different charts on each tab. The Excel file has
at least 20 tabs and I would like to export them into Word as a separate
sheet per tab for a reference guide. Is there a way to export from excel
without having to cut and paste each tab?
I am using MS Office 2003.
...Insert with a where condition
Hi, sql 2005
I have an insert statement that is ignoring the where condition. That is, I
want to insert records when they do not already exist in the destination
INSERT INTO dbo.tblmnuGroupPerm
FROM dbo.locmnuTabFunction AS ltf
ltf.mtfID NOT IN
FROM dbo.tblmnuGroupPerm AS gp
Any ideas or recommendations appreciated :-)
It's OK... <oops "redFace">I did not correctly se...Problem while saving a shared excel'07 document
Hi, in my bussiness, we have a shared excel 2007 document.
This document worked fine with Excel 2003, but now we're migrated to 2007,
we've got all kind of problems..
When I try to save the document, 6 out of 10 times, the saving failed with
an error that Excel could not track changes. You should close the document
and try it again, but then you loose all you're changes. You can also turn
'Share Workbook' off, and on again, then you can save the file, but all the
changes other people have made are gone...
I can't find any solution, so maybe there's...How to copy specific columns until end of data
I'm trying to import data from 2 workbooks into a summary (combination)
workbook. The trouble I'm having, is I want to import only certain
columns and have excel know to stop at the last row with data.
For example, from Workbook1 I want to import columns A, B, C, F, and G
(from Sheet2). I want it to copy up to the last row containing any
data--right now that's row 1046, but next month it could be row 1267.
In workbook2 I'm fine with it copying the CurrentRegion--all columns
are important. BUT, it doesn't include the title/category heads in the
first row (Salesperson, ...showing data values on chart
in excel when mouse stand on chart,excel is showing the data values of that
point.how can to do this action in access?
Exactly the same. When you hover the mouse over a data point for a little
amount of time, a yellow bow should come up describing what's in your data
> in excel when mouse stand on chart,excel is showing the data values of that
> point.how can to do this action in access?
Where you insert chart?i insert chart on report,and i can't to see data value
on data point.
"Steve"...What exactly is microsoft excel used for?
I just need to know what excel is used for.
Wow, what a question!!!! It is used for so many things, that books have
been written about it. Spreadsheets, Databases, to manipulate data of all
sorts, by using templates, as payroll packages, invoicing systems, creation
of form letters, automating tasks, and and and and
> I just need to know what excel is used for.
> I just need to know what excel is used for.
...Calculation of weather data help
I have a data file (at http://www.weatherweb.net/cliall.dat) which contains
daily weather data from 1881 in the format:
dd,mm,yy,max temp,min temp, rainfall, sunshine, wind speed, wind gust,
What I would like to do is to calculate means for max, min, wind speed, wind
gust and pressure, and also total rainfall and sunshine for each month.
I would like the output in the format:
mm,yy,mean meax, mean min, total rain, total sunshine, mean wind, mean wind
gust, mean pressure
Can anyone give any assistance as to how I might do this in excel to create
a sngle file contain all th...