Cannot change line/object color in Publisher 2002
Anyone who can help:
I'm using an older version of Publisher (2002). I was working on a floor
plan for a project when suddenly, all the lines and borders disappeared. I
am now unable to make any selection to change the line color--the selection
defaults to a blank option no matter what color I choose, creating
essentially invisible objects and lines in my files, even new ones.
I uninstalled and reinstalled Publisher twice to no effect--the problem
persists. (Interestingly, the same files when opened in Publisher 2002 on
another machine display fine.)
Is there something else that co...Pivot table will not returned value's
Yesterday i made a macro which gets the value from Cell AM1 and fits it as a
criteria in a Pivotfield in another file.
The macro as seen at the end, works smooth except for this part:
Set pt = Sheets("Table Combi").PivotTables("PivotTable3")
Set pf = pt.PivotFields("ARF Code")
ActiveSheet.PivotTables("PivotTable3").PivotFields("ARF Code").CurrentPage =
"" & k & ""
If pf.CurrentPage <> " & k & " Then
pf.CurrentPage = "(Blank)"
Does ...Change line to bar in Line
Hope someone can help on this one...I have 4 data series that I am trying to
plot on a Line-Column chart. I need 3 of these to be columns and one to be a
line. It is defaulting to 2 columns and 2 lines.
Does anyone know how to override that default, so I can change the one line
(basically the 3rd data series) to a column?
Select the series you want to change, then on the Chart menu, choose Chart
Type, and choose the new type to assign to that series.
Next time, starting from scratch, make a column chart with all four series,
then change the one to a line.
I've seen some posts regarding a similar problem to what I'm having but cant
find the resolutution!
I have a database with tableA which contains basic inventory info. I have a
field in tableA named location. There is a second table (tableB) which has
a list of all the locations our company delivers to.
I've been warned to stay away from lookup fields, so I'm using combo boxes
on the form to look up the location and then populate the location field in
tableA when the value is selected.
Here is the issue (and again, I've found some posts similar): Running a...sql server 2000: most frequented tables -> script wanted
could someone please provide me a script, which throws the most frequented
tables used within a sql server 2000 database?
i am aware of one (see below) for sql server 2005, but due to new
functionalities within sql server 2005 it can not be backported.
SELECT TOP 20
FROM sys.dm_db_index_operational_stats(NULL, NULL, NULL, NULL) WHERE
db_name(database_ID)='<Datenbank-Name>' ORDER BY leaf_update_count desc
--oder ...25 changes to 35
When the value of 25 is entered into a cell, the screen returns the value of
I have scanned for viruses, tracking software, defalt setup values,
uninstalled an reinstalled excell, updated, etc. Still I get a value of 35
when I enter 25.
Check Tools>AutoCorrect Options and see if someone is playing a trick on
"David Sound Tech" <David Sound Tech@discussions.microsoft.com> wrote in
> When the value of 25 is entered into a cell, the screen returns the value
&...Query to Access : does'nt see tables
Office 2000 SP3 FR
From Excel / MS Query, I want to read data in Access tables.
I choose the mdb file and so MS Query displays this error message
"This data source does'nt have any visible table".
Original in French : "Cette source de donn�es ne contient aucune table
I transfert my data to a new mdb file : it work's few times (!), then the
error message appears again.
How to resolve this problem ?
MS Query does'nt accept a file name with 2 dot inside !
MyFile.mdb --> Ok
My.File.mdb --> "...% of running total in pivot table
Does anyone know of a way to include in a pivot table a % of total for a
I'm not sure if I'm saying that right, so this is what I'm trying to do
1Day 2Days 3Days
# completed 100 50 20
# completed (running total) 100 150 170 190
% completed (of running total) 50% 75% 85% 95%
The last row is what I'm struggling with. I can easily get ...Changing Depre Life
I have a number of fixed assets that I need to extend the life. Their in
service date was in the prior fiscal year. If I go to the Asset Book screen
& change the life, <save> the screen & choose "Year" as the reset option (not
Life or Recalculate), shouldn't I get some financial entries reflecting the
current year adjustment of depreciation?
I tried it in the test company & I'm not getting any GL entries. Any help
You have to run the GL Posting Routine at Tools>Routines>Fixed Assets
to generate the GL entry.
Fr...About worksheet change event.
I wrote a code and somewhere, I want to restrict any changes with multiple
cell selections, "except" adding a whole row by right-clicking on the row
number bar. How can i do this?
Maybe you could test like this
If Target.Rows.Count = 1 And Target.Count = Rows.Count Then
(remove nothere from the email address if mailing direct)
"serdar" <firstname.lastname@example.org> wrote in message
> I wrote a code and somewhere, I want to restrict any changes with multiple
> cell selections, "except"...Pivot report without the drop downs
I created my Excel 2007 Pivot table with the data I need. Now, I want
to remove the Report Filter Drop Down showing lot more information
than my peers or superiors need to see or even try to view.
The same is true for the Rows Labels and Column Labels with the drop
I figured out how to remove the plus signs by using the "Show/Hide" on
the Options on the Ribbon.
I tried the copy and paste but for some reason I can only do .txt or
object. There is no paste special. Then the format is not the same.
Do anyone have an answer for this problem?
Thanks a million,
...Add more than one series to a pivot chart using VB MS Access continued...
I'm trying to programmatically create a stacked bar pivot chart.
Using "Programming Microsoft Office Access 2003" by Rick Dobson, I've
created the chart. However, it doesn't distinguish between the
different values for the series. Does anyone have any suggestions on
how to create a chart using one column containing three values for the
Essentially, this is a continuation of a previous post:
Any help is greatly appre...Summing a selection of lines in a pivot table
Probably a totally newbie question on pivot tables but I can't seem to
find out how it works. Here's my problem:
I've got an Excel worksheet that (coming in from jet reports) contains
#Asset 1 Description A1 Total A1 Mapping A1 = X1
#Asset 2 Description A2 Total A2 Mapping A2 = X1
#Asset 3 Description A3 Total A3 Mapping A3 = X2
#Liability 1 Description L1 Total L1 Mapping L1 = X3
#Liability 2 Description L2 Total L2 Mapping L2 = X4
#Liability 3 Description L3 Total L3 Mapping L3 = X4
This last field, mapping, is what's important for my pivot table; it...VBA to export large tables from Excel to SQL Server
I have spreadsheets that I distribute to users. I want Excel VBA to export
large tables (2000+ rows) into a remote SQL Server 2005. I am able to
successfully do this with the following generic code, but it is too slow:
Dim con As ADODB.Connection
Set con = New ADODB.Connection
con.Execute "INSERT INTO ... SELECT * FROM ..." 'Looping this for each
It takes over 10 minutes because it does it one line at a time.
I've also tried l...Change the default Calendar
Hej to all
I have outlook 2010 with 2 calendars, calendar and work. By default the
default calendar is calendar, but I would like to be work, since calendar
have almost my private things, there is a way to change the default calendar
Thanks to all.
No, you'll have to copy over the items from one to the other.
Personally I don't use 2 calendars for this but use a single calendar and
categorize my appointments accordingly.
For details see;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft...RWW, VPN, Exchange connection problems
Running SBS2003 on an HP server. 3 PCs used by onsite staff. 4th PC used
for remote access via RWW. Having intermittent connectivity issues. I sign
in remotely using an XP workstation w/RWW. I have another PC that I use to
access Exchange, and occasionally connect with VPN to access files on the
server at the office.
I keep getting dropped on RWW with the error "VBScript Remote Desktop
Disconnected. An internal error has occurred". When that happens, I also
notice that my Oulook client on the other PC shows an error that the
connection to Microsoft Exchange has ...Strange connectivity issue
Windows XP SP3, Dell laptop. Cannot ping the default gateway, which is our
router. Can ping any other computers on the subnet, either by hostname or
IP. Other computers on the subnet can ping this laptop, either by IP or
Cannot ping the laptop from the router.
The laptop has built-in wireless. If I enable that, I can ping the router's
I tried resetting TCPIP with this command:
Netsh int ip reset
Windows firewall is disabled.
The computer does not appear to have any viruses.
Nothing in Event Viewer.
I'm stumped. Any ...Publisher mailmerge error message, invalid office data source
I am trying to edit a mailmerge database I started in publisher, but I keep
getting an error message, "This is not a valid office data source". But it
was just fine earlier.
Are you creating the list in Publisher? What version Publisher? Look in "My
Documents", "My Data Sources", is your data base there?
Is there a number associated with your error?
Mary Sauer MSFT MVP
"Obrother" <Obrother@discussions.microsoft.com> wrote in message
We have recently migrated to a new exachange server, still running 5.5 though. We reconfigured all of the outlooks clients to point to the new server.
For some reason, some of the clients continue to function slowly, with a message coming up saying something to the effect of "Please wait while outlook accesses data from FS1 (the old exchange server)". So the clients are looking for something from the old server, which is no longer. We have totally wiped all email settings multiple times, but the problem continues.
What about Public Folders? Did you replicate them ov...Pivot Tables #9
I have a list like below
Ref Client Name Team TeamMat
1 John 1 Ia
2 Steve 1 Ima
3 Andres 2 Jiv
4 Micel 1 Ima
5 Miquel 2 Jiv
I wante to create pivot table to count the unique number of people in team, above team 1 has 2, team 2 has 1
Cant seem to do it with pivot table, is there way or create different type of table useing formulae
Thanks for hel
b...Change the name of an auto save
I am trying to write a macro that will save the file to a specific cell
reference. The reference is a specific name that is automatically generated
by another macro function.
Any suggestions on how I could do this?
IS thsi what you want?
sFilename = Format(Worksheets("Sheet1").Range("A1").Value)
ans = MsgBox("Save file as " & sFilename)
If ans = vbOK Then
If this information was helpful, please indicate this by clicking ''Y...Auto date changing in Excel is maddening
I'm using MS Office Excel 2003 (11.6113.5703) to post data that spans over
or try http://tinyurl.com/6f8zn
We had to jump through all kinds of work-arounds in order to accomplish
this. It was not a straight-forward process, though it should have been.
When I enter the date format, for example, as
Format > Time > 3/14/01 13:30
And then enter 11/17/04 0:30:30, it enters okay, but when I double click on
the cell to edit it, Ex...changing the scale from hours to days in the Resource Usage view
My current Resource Usage view shows my resources and the hours allocated for
each resource in hours. How can I change this view so that it tells me the
allocated effort for each resource in days, as opposed to hours?
thanks in advance.
Tools > Options > Schedule > Work is Entered In....
- Andrew Lavinsky
> My current Resource Usage view shows my resources and the hours
> allocated for each resource in hours. How can I change this view so
> that it tells me the allocated effort for each resource in days, as
> ...How do I change the color of tabs in word 2008 notebook layout?
I've been trying to figure out how to change the color of the section tabs with no success. Does anyone know how to do this?
In article <email@example.comR9absDaxw>,
> I've been trying to figure out how to change the color of the section tabs
> with no success. Does anyone know how to do this?
Right- or ctrl-click the tab and choose a color from the Section Color
I'm looking for the same thing; in addition - how to delete extra tabs.
Ctrl-/right-click a tab, and you can change its colour as well as delete the
tab (a...change cells contents from vertical to horizontal
I need to copy from one workseet the values in cells that are arranged
vertically into another worksheet and the values need to be arranged
horizontally. Can this be done? If so, how?
Select the data to be copied>Copy>Select target cell>Right
If this post helps click Yes
> I need to copy from one workseet the values in cells that are arranged
> vertically into another worksheet and the values need to be arranged
> horizontally. Can this be done? ...