If I attempt to send HTML mail, recipients outside our
corporation receive the message in rich text format. Other
doesn't have that problem. What settings should I check?
...Pivot Table not pulling all fields or data
Without getting too verbose, I have a 900 row by 26 column database I am
applying a Pivot Table to. The code seems to run fine, but it is not
returning some of the fields, and of course the related data. I have tried
reformatting the entire columns I am pulling from but no joy......however,
when I reformat an errant cell from General to TEXT, that row comes
in........and/or, if I change the value in one of the missing cells, it will
bring that row in. The code runs fine, and was mostly derived by recording
a macro in XL2k, but the data cannot be trusted becau...How do I automatiicaly redefinie Source data range for a chart?
I have A Chart Defined by Category (X) values in Collumn B and Y values in
Collumn C. Right now Both are defined by rows 4 to 114.
I would like to be able to have the chart automatically redefine itself so
if I put a value in C115 the chart would automaticaly set Y value range to be
C4:C115 eithout having to manually define chart. Is this possible? If so
how? I've tried OFFSET bu so far no luck.
If you turn your data cells into a List, or Table in xl2007, the chart will
The named range approach will work if you set up the names correctly.
See here for more info...Avery label format to landscape.
I would like to change the format for Avery label # 5164 from portrait to
landscape but the option is grayed out.
Create a text box that will fit, rotate it clockwise 90�, create your label,
rotate it counterclockwise (or anti-clockwise) 90�. Ta dum
MVP Microsoft [Publisher]
"wpgmb" <firstname.lastname@example.org> wrote in message
>I would like to change the format for Avery label # 5164 from portrait to
> landscape but the option is grayed out.
...Formatting Text in a Forwarded Email Message
Odd problem in Outlook on one of our pc's. We are using Outlook 2002 SP3.
When attempting to forward a message, I sometimes change a few of the words
in the body of the message. I place the cursor within the word I wish to
change. As soon as I type one letter, any letter, the letter shows up two
font sizes bigger (from 12 to 14), and with a space on each side of the
What seems to make this more puzzling is that when I attempt the same task
on our other pc, everything functions as it should; no change in font size
and no extra spaces.
Any help in eli...Exchange data backup
I'm worried emails backup of the small office.
Does SBS2008 Exchange server has a direct backup capability of whole mail
How to backup every night Emails from server to external harddisk?
Does Exchange server needs to be stopped before backup?
SBS2008 Takes care of it.
look at the comments section
Russell Grover - SBITS.Biz [SBS-MVP]
MCP, MCPS, MCNPS, SBSC
Microsoft Certified Small Business Specialist
24hr SBS Remote Support - www.SBITS.Biz
Question or Seco...custom format
I need to custom format my Y axis the only on the top number of the scale to
appear with the $ sign and the rest of the numbers #,###. Thanks
You could use one of the axis label tricks that Jon Peltier explains here:
John Knoke wrote:
> I need to custom format my Y axis the only on the top number of the scale to
> appear with the $ sign and the rest of the numbers #,###. Thanks
Excel FAQ, Tips & Book List
A simpler solution is to change the ...Data Save error
GP Ver 6.0. Recently I am facing an error with normal users unable to save
records, where as the system administrator is able to save the same
information. Please advice on this error, what has to be done.
I have disabled the windows user ID of the Database owner. Thinking of this
made Dynasa as the DBO.
Database is having enough free space available.
How big is the company database? Is it over 10GB?
"Matthews" <Matthews@discussions.microsoft.com> wrote in message
> GP Ver 6.0. Recently I...My format toolbar dissappeared and won't come back... Outlook 2003
I don't mean, grayed out. I mean not there. HTML, Rich text, doesn't
Is it turned off or actually deleted? Did you try resetting toolbars?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newslette...Managing multiple worksheets 03-24-10
Operating System: Mac OS X 10.5 (Leopard)
I regularly create files with 50+ worksheets with interlinked references - mostly historical and projected financial statements. Is there anyway possible to group files in a folder in the tab bar at the bottom of the sheet for ease of navigation? For example, can I group together all worksheets for 2009, 2010 etc in separate folders that can be expanded or contracted for ease of navigation? <br><br>Thank you
On 3/24/10 12:16 PM, email@example.com wrote:
> Version: 2008 Operating System: M...Book1
C:\Program Files\Microsoft Office\Office10\XLStart\Book1.xl
mdalby's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=705
View this thread: http://www.excelforum.com/showthread.php?threadid=26311
The template should be named Book.xlt, not Book1.xlt.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"mdalby" <firstname.lastname@example.org> wrote in message
>...Worksheet protection problem
I am using Excel 2000, wanting to protect certain cells, but allow user to
filter using autofilter, etc. and how would I do this?
Private Sub Workbook_Open()
Worksheets("Sheet1").EnableAutoFilter = True
Right click on the Excel icon next to File in the menubar
choose view code
paste the code
Alt-Q to go back to Excel
This runs every time the workbook opens. It protects the worksheet and
allows users to use the AutoFilter dropdown lists.
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002...cell range not changing when refreshing linked data- sumproduct fo
The cell range is not updating correctly to reflect the last row in the data
sheet that is being refreshed. 5878 is the correct number of rows and 5824
is not. I can find and replace in my formulas to correct the problem, but it
does it each time the data is refreshed. Any suggestions as to why?
I gave you the INDIRECT option y'day, but received no feedback from you in
that thread. Looks like you're more interested in knowing why? One simple
hunc...Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms,
modules, and logic) used to CRUD the data in the tables.
1) Is there any way to separate the database from the code into separate
files, eg. the db is mydata.mdb and the 'code is in a separate file, eg.
2) Say you have v1.0 of an app and the tables and attributes are populated
with data. You then go and build v2.0 of the app, adding tables and columns
to what already existed in v1.0, and perhaps moving some of the v1.0
attributes into different tables. What is the recommended way to
unload/reloa...website links in IE8
Links stopped working on websites. They worked yesterday, but not today,
Although those links will work on a different computer.
Tools>Internet Options - Security tab, click "Reset all zones to default"
PS. Its a good idea to leave your IE Security zone settings at their
'default'/'factory' settings instead of changing them in the hope of getting
some web features working on individual sites. Adjust security for web sites
by either adding them to the Restricted or the Trusted Sites Zone.
"fjs69xr7" <fjs69xr7@discussio...Link Error
I have added the "afxcmn.h" to get the "CImageList" type to do some
graphical interface enhancements.
The Programs compile fine, but I run itnot Problems during Linking..
I know this is not the Forum, but if something is obvious , please do point
it to me.
this is how I added it to my 'StdAfx.h'
#include <t...Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in
It is customer ID name and billing info but it is like a long series of
I want to be able to have them listed under captions like company name,
contact, address, city, etc.. so I can use the data.
There is an empty row between each entry. Each entry is 3 or 4 rows.
There are about 500 records so i dont want to manually set them up.
Try tinkering around with these steps
Assuming your list is in col A,
data in A2 down
(If data starts in A1 down, insert a new row for the co...Link Errors __endthreadex and __beginthreadex
I've started to teach myself Windows Programing with Visual C++ 6.0 with SP6.
I'm using "MFC Programing from the GROUND UP" second ed. Copy his examples
into a new proj. with new workspace set for an empty win32 application. They
compile with no errors but I have Link Errors on "unresolved external symbol
__endthreadex" and unresolved external symbol __endthreadex" and
What am I missing?
Thanks for any help forthcoming.
you forget to enable support of MFC dll in your project,
Enable it from following location Project|setting or pres...Linking text to style for auto update
I want to auto update figure/table number in text to that in Figure/Table
Use Insert > Cross Reference to put the numbers into the text; they
don't update every time the numbering changes, but only when you tell
them to (Ctrl-A, F9) or when you print or switch to Print Preview.
On Dec 18, 4:05=A0pm, Taurus <Tau...@discussions.microsoft.com> wrote:
> I want to auto update figure/table number in text to that in Figure/Table
> style numbers
...Display comments as data #2
thanks a lot , this worked exactly as required, the comment go
converted to data
Now just one more thing . is the vice versa possible i.e if i have dat
in column A can it be shown as comment in column B.
the reason i need this is bcos i am shifting some data with thei
comments to MS access(Hence the need to convert omments to data)
processing them and again converting them to excel (the need to conver
data back to comments
sonika's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...Count invalid data entries
I am using the following macro to identify invalid data entries in
cells with data validation applied.
' Application.CommandBars("Formula Auditing").Visible = True
MsgBox ("Check for Red Circled Invalid Data Entries on" & Chr(10) &
" Configuration and Parts_TakeOff Sheets")
Is there a way to count the number of invalid data entries (red
circles) and write the number to a particular ce...Can't link a graphic?
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
Email Client: pop
I've been told on this forums several times that one cannot have a graphic with live link in your email signature. <br>
Still, I've recently received a few email with small buttons that link to facebook and myspace in Entourage. How are these folks achieving this? thanks.
> Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power
> PC Email Client: pop I've been told on this forums several times that
> one cannot ha...Changing Worksheets
Is anyone aware a keyboard shortcut that will allow you
to 'move' from one worksheet to another within the wame
I'm looking for something similar to the ALT+TAB used to
to 'move' from a active window to a different window.
Adam Eichenberger wrote:
> Is anyone aware a keyboard shortcut that will allow you
> to 'move' from one worksheet to another within the wame
> I'm looking for something similar to the ALT+TAB used to
> to 'move' from a...forms not listed in database contents, yet can add data to them
Hi - there are no forms listed when I open up the database in design view.
All the tables, queries, and macros are there.
When I open up the database to add data, all the forms are there and can be
used. The data is stored. So, it seems that the forms are still there, but
just cannot be seen in design view.
The database, when I open it up in design view, says Access 2000 file object
even though I am using Access 2003 - could that be the problem?
You cannot open an entire database in Design View. Try opening it normally,
selecting a form, and choosing Design View from the V...can't move chart to new worksheet
I am creating a an embedded chart and then move it to another worksheet that
would contain all my charts.
After I create the chart I want to move it to another sheet. here is my code:
ActiveWindow.Visible = False
ActiveWindow.WindowState = xlNormal
ActiveWindow.WindowState = xlMaximized
ActiveSheet.PasteSpecial Format:="Picture (Enhanced Metafile)",
It gives me an...