the criteria pane and table panes have disappered.
In my excel file I can't see the criteria and table panes and the functions
will not reappear.
...Formatting Numbes to Text
I have a spreadsheet that contains the following data:
Date Account ID
When I save it as a .csv file it looks like this:
Date Account ID
5/14/2...Transparent Text Box Over Another
I am trying to place a semi-transparent text box over a
document. The problem is that the text in the underlying
boxes moves around the new box rather than staying fixed
where they are. How can I fix this?
I'm curious - what do you mean by "semi-transparent"? Do you mean something
like a watermark?
JoAnn Paules - MVP Microsoft Publisher
"Cindy" <email@example.com> wrote in message
> I am trying to place a semi-transparent text box over a
> document. The problem is that...Word hangs when I try to edit text
Operating System: Mac OS X 10.6 (Snow Leopard)
I can open documents, but when I select text to edit, try to add a return or a shift, it hangs. All I can do is force quit. It's really annoying! All the updates are up-to-date, and it worked just fine the other day. <br><br>What's going on? And how can I fix it? <br><br>Thanks!
That sounds like a corrupt document.
Try saving it as a web-page, then quit, re-open, and re-save as a Word
If it hangs during the Save As, try a Maggie:
1. Create a ne...caption, text box, and frame
I inserted a picture (a bitmap), cropped and sized it to fill the page
from side to side, and positioned it 1.5" from the top "margin" so
that it would be at the top of the text area.
I then clicked on Insert Caption and got the usual panel offering
"Figure 1" as its label. Instead of simply inserting a paragraph in
Caption format as usual, it inserted a text box with the caption label
in it. When I typed the content of the caption, the following body
text reduced to a single line. Dragging the picture's anchor to a
different paragraph made whole paragrap...Publisher 2007 -how to view all pages in bottom row of taskbar
I've upgraded from 2003, and now the pages of my webpage listed on the bottom
of the Publisher window are all missing (my website pub. document contains 10
pages, which were visible as number rows at the bottom underneath the
document within the publisher taskbar frame). I cannot select a page any
more. How can I get this page row back?
Thank you in advance for your replies.
> I've upgraded from 2003, and now the pages of my webpage listed on
> the bottom of the Publisher window are all missing (my website pub.
> document contains 10 pages, which were ...Publisher
Have set up a small report 10 pages in total but when printing page 9 I get
additional blank pages printing and then my page 10 how do I stop this from
Open the Design Checker, see if it tells you anything. Is the page visible in
What version Publisher?
Is the publication setup as a booklet? Publisher works in groups of 4 when
printing a booklet. With a ten page booklet setup, Publisher will print a blank
"charliegirl" <firstname.lastname@example.org> wrote in message
Hello, I do not have deep knowledge of Excel. That is why my proble
might appear a bit strange:
I have two tables, list1 and list2. In both tables there is a colum
with unique ID numbers. The rest of the columns contains differen
information in both tables. Example:
ID name email
101 bob email@example.com
102 rita firstname.lastname@example.org
999 jim email@example.com
What I would like to get as a result is a combined table, with selecte
columns from both tables in it. I.e.:
ID name salary
101 bob -
102 rita 2500
Anyone who can ...Need to set up a slide with 4 text boxes on same page.
Want to end up with 4 "bulleted" boxes that I can to show 4 strategies and
associated task on same page. Also, if possible have each one drop in
individually to allow flow conrol for the presentation
Are you asking a question about how to do that or having trouble with part
If the former, just create four separate text boxes with bulleted text, you
are not limited to only one text box per slide. Use the Custom Animation,
Effects Options, Text Animation settings to control the entrance of the
Since you didn't say what version of PowerPoi...Add Text Field Columns
I have two fields both of which are text. When I try to add them as above, I get a
concatenated result, not the sum. How does one add them?
On Fri, 18 May 2007 17:38:49 -0600, bw wrote:
> PFDB: IIf(Nz([PFDirect])+Nz([PFBulk])=0,"",Nz([PFBulk])+Nz([PFDirect]))
> I have two fields both of which are text. When I try to add them as above, I get a
> concatenated result, not the sum. How does one add them?
How does one add "This is text." + "this is also text&qu...how to change the icon text
What event to I do to handle when my app get iconified? I Need to set the
window text for my icon differently than my app title bar text.
When I run my app, the window text for the app title bar is "foo", when the
user iconifies the app, I want the icon text to be "bar".
How do I do that?
Thanks for the help,
Take a look at CWnd::OnSysCommand. SC_RESTORE and SC_MINIMIZE is what you
want to look for in this method.
Ajay Kalra [MVP - VC++]
"reza razavipour" <firstname.lastname@example.org> wrote in message
news:uK18XkXH...Pivot Table fields #2
Is there a way to format multiple pivot table fields at
one time and have them refresh that way, rather than
having to select each column and choose the format
I think the solution for you is to open the Pivot Table
Toolbar and select the Field Settings icon. This sets the
format for all results for that particular field.
One limitation that I haven't found a way around is
getting a preferred column size to "stick" and not reset
after a table refresh.
>Is there a way to format multiple pivot table fields at ...Copy chart with reference table
I have a pie chart neatly tied to a data table alongside. Now I want to copy
both the chart and table to a different area of the sheet so I can modify the
new data table and have 2 different charts.
My issue is that the chart will only allow absolute references, so when I
copy both the chart and table together the new chart still is tied to the old
table - so I have to go and change the source data ranges one by one.
Any way that I can do this easily?
Copy the whole sheet. The copied chart links to the data on the copied
sheet. Now cut the range that includes the copied char...Excel 2007 dates and conditional formats
Can anyone please tell me why I can not use a conditional format (<>=)
to identify if a date is greater or smaller then another. Everytime I
try it, Excel does it right in the first column but misses by 2 days
in all following. It also appears to have problems with the years.
Date of propposed compleation of a task is 10/10/07; if the date of
actual completion is 10/10/07 or sooner, turn GREEN. If the date of
completion is 10/11/07 or older, turn RED.
Can anyone help??
First thing to check:
What does 10/11/07 mean?
November 10 1907?
November 10 2007?
O...Pivot Table Refresh Problems
Hoping that someone can help. I am trying to refresh a pivot table
using the following code which was inserted on the Daily Production
Output Sheet(both sheets in the same workbook). I am using Excel 2003
Private Sub Worksheet_Calculate()
'If data on this worksheet changes, refresh the pivot table
The Calculation has been set to Automatic.
However when I try to run the above code I am getting the following
error" Run Time error 1044, Application defined or Object defin...automatically sizing text with graphs
hi, is there a way to make the text in my charts size proprotionally
with the graphs when i move them to another location (eg: a different
sheet or chart)....I seem to have a problem with the way the graphs
shrink but the text retaining their original size after i move them.
Shoque's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36320
View this thread: http://www.excelforum.com/showthread.php?threadid=566948
Right-click on the axis labels and choose Format Axis. Go to the Fon...Excel 2007 exits without asking if I want to save
I just started using Excel 2007 recently. I notice it exits when I keys in
Alt-F4, without confirming if I want to save, even if I had made changes to
Is there an option which I can set and make Excel 2007 verify if the user,
wants to save before exiting? This is the default in earlier Excel versions.
Thanks for help.
have you recently run a macro in which you forgot to turn on
Application.DisplayAlerts =3D True?
On Nov 24, 5:25=A0am, ch <c...@discussions.microsoft.com> wrote:
> Hi All,
> I just started using Excel 200...pivot tables #19
I want to create a pivot table where I just have to enter the data in once where it will post to a general ledger, income/expense statement, profit & loss report and individual vendor accounts. Can this be done?
Look at my Excel Database Tutorial at
You should be able to work it out form there.
> I want to create a pivot table where I just have to enter the data in once
where it will post to a general ledger, income/expense statement, profit &
loss report and individual vendor accounts. Can this be done?
&...Using a Text / Data output as a cell reference
I am trying to use the end of a column as a divisor and need to convert what
i guess is text into an actual cell reference if possible.
In column A, say there are 13 data points ending at cell A13.
I then try to turn that into a cell reference with the formula
="A"&TEXT(COUNTA(A1:A13,),"0") I put this formula in B1
the output of this is then A13
what i need this to do, is be able to divide any cell by A13.
The reason I am going through all this trouble is that there are many
columns and each has a different # of data points.
I hope this is somewhat clear. Thanks ...Modify Access 97 tables in Access 2003
How do I modify an Access 97 table using Access 2003 without converting the
database? Is there any tool available?
This is only one person's experience...
There is only one tool I'm familiar with that would let you do that, and
it's called ... Access '97<g>!
You've described HOW you want to do something. Now, if you'll describe a
bit more about WHY you need this done, the folks here in the newsgroup may
be able to offer more specific suggestions.
Microsoft Office/Access MVP
"Rick" <Rick@discussions.microsoft.com...Copy and paste from Excel to GridView
is it possible to copy and paste values taken from an Excel spreedsheet into
the grid of a GridView in a ASP.NET page?
On May 21, 4:29=A0pm, Luigi <Lu...@discussions.microsoft.com> wrote:
> is it possible to copy and paste values taken from an Excel spreedsheet i=
> the grid of a GridView in a ASP.NET page?
You mean from a single cell or entire table?
The standard gridview control is a data-bound control for rendering
data. It has no paste function. To copy and paste values from Excel
you can use a separated textbox...TEXT TO SPEECH CHANGES
Currently my text to speech config reads ONLY LETTERS if the letters are
CAPITALs(IE when it come to the word ABLE, it speaks A B L E
how can I change the setting to make the system say "able"
Enter this small macro:
For n = 1 To 100
And it should "say" whatever text you enter in A1 thru A100
> Currently my text to speech config reads ONLY LETTERS if the letters are
> CAPITALs(IE when it come to the word ABLE, it speaks A B L E
> how can I change...Nesting? How do I create a table to reference?
Tried to nest more than 8 componets but it did not work. Any help on
creating a table to reference it would be appreciated. Never done it
before. Tried the Excel help, and it was worthless.
Here is my original post that explains more:
mcr1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15496
View this thread: http://www.excelforum.com/showthread.php?threadid=498905
ok you have a two column table.starting in the lh column you...How do I sort a pivot table
Operating System: Mac OS X 10.6 (Snow Leopard)
I'm trying to do a very basic function but I can't figure it out for the life of me. Please help!
...business contact manager will not import ACT! 2007
Just upgraded, but my new version of ACT! 2007 will not work. I tried
exporting to CSV but mapping was off.