Pivot Table not pulling all fields or dataHi All........
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...
Outlook and message rules- can't get one to work?I have set up message rules to divert mail from my inbox to various sub
folders or new folders. I use these:-
Check messages when they arrive\ from people or distribution list \ with
specific words in the senders address \ with specific words in the subject or
body
Now the problem is that some of the messages are recieved from people in my
address book and when they send a message sometimes their name and address is
in the 'from' and other times it is just their name and so the ones with just
their name do not get moved across to the folder I want. I have added their
name or...
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.
Hi,
If you turn your data cells into a List, or Table in xl2007, the chart will
auto expand.
The named range approach will work if you set up the names correctly.
See here for more info...
Deleting Actual Work Deletes Protected ActualsI am running Project Server 2007 with SP2 and Feb 2010 CU. I am using
the Task Setting Restrict Updates to PWA. However, when I delete all
the Actual Work for a resource in Project Pro, clicking Sync to
Protected Actuals does nothing. In addition, all the hours entered
via My Tasks of PWA are gone.
Has anyone else experienced this bug?
Hi Andrew,
Is your Project Professional client also running SP2 + CU? I have seen what
you mentioned but it was a bug that affected SP1 and I'm pretty sure it was
fixed before SP2...
Specifically the bug I recall was that it was possibl...
Exchange data backupI'm worried emails backup of the small office.
Does SBS2008 Exchange server has a direct backup capability of whole mail
database?
How to backup every night Emails from server to external harddisk?
Does Exchange server needs to be stopped before backup?
Thanks
SBS2008 Takes care of it.
http://blogs.technet.com/sbs/archive/2008/11/03/introducing-sbs-2008-backup.aspx
look at the comments section
Russ
--
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...
Data Save errorGP 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.
Hi
How big is the company database? Is it over 10GB?
Regards
James
"Matthews" <Matthews@discussions.microsoft.com> wrote in message
news:3FF3F553-5B18-4D8A-B65E-8A253BF94BB2@microsoft.com...
> GP Ver 6.0. Recently I...
Getting a filename into VBA and putting it into cellsBasically what I have is a button that creates a new column that should be
full of linked values. When the user hits the button, he is asked to select a
file from his hard-drive; the code then takes the name of that file and
creates a number of links in the new column. So for example:
1) User hits button and selects the closed excel file
C:\Tempfiles\Testsheet.xls
2) Excel creates the new column and populates it with formulas that link to
the file; in A1 it enters
='C:\Tempfiles\[Testsheet.xls]Overview'!$A$1 in A2 it enters
='C:\Tempfiles\[Testsheet.xls]Budget'...
I deleted a tab in OneNote, is there some way to get it back?!I'm using Microsoft Office OneNote 2007.
I had a tab that I wanted to delete, but I accidently deleted the wrong one!
I didn't notice until several minutes later after messing around in O.N. some more.
After I freaked out, I click the undo button.
A lot.
But eventually the button went gray and wouldn't let me undo any more things. And still* didn't get my tab back. Is there some way to get it back?!
Pleassseeeee help!
EggHeadCafe - Software Developer Portal of Choice
Essential ASP.NET With Examples in C#
http://www.eggheadcafe.com/tutorials/aspnet/8f709566-1d04-...
Auto-Calculation Not WorkingI have a workbook in Excel 2003 that I update frequently. Occasionally, the
workbook will not update formula results after a variable or data has been
changed. Auto-calc is selected on each sheet. Pressing F9 does not do
anything. I have to press F2 on each cell and then press <enter> to get the
cells to update individually (quite a chore). I have not observed any common
issues when this occurs. Does anyone know a fix for this?
Try pressing CTRL+ALT+F9. If that doesn't work, you can always use search and
replace to search for an equal sign and replace it with an equaL sig...
Where could I get flexi-arrows?Hello,
I am newbie in Visio 2003, but need to draw some diagrams. I don't find
flexi-arrows (no connectors, just arrows that have to be flexible and
circular shape, starting and ending at any point).
It seems that MS default Visio stencils don't come with that kind of
arrows.
Where could I donwload or find this kind of shapes?
Thanks!
...
cell range not changing when refreshing linked data- sumproduct foThe 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?
=(SUMPRODUCT((Expense!$B$2:$B$5878=$C$2)*(Expense!$C$2:$C$5878=$C$3)*(Expense!$W$2:$W$5824=$A6)*(Expense!$M$2:$M$5878)))
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 questionsA .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.
code.mdb?
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...
Getting Windows Installer error message when starting Office appliWhen I start an Office application I initially get a "Windows Installer"
window to pop up stating "Preparing to install...". Approximately 30 seconds
or so later a window pops up titled "Problem with Shortcut". The statement
in this window is "This update package could not be opened. Verify that the
update package exists and that you can access it, or contact the application
vendor to verify this is a valid Windows Installer update package."
I am running Vista and Office 2007. This has not been a problem in the
past. It appears a recent...
Outlook 2002 was working fine but now will not reply, get relay erOutlook 2002 was working fine. Switched to DSL and now we can not reply to
some addresses. Using MSN Premium for an ISP. Any help would be
appreciated. Qwest techs will not support Outlook.
...
UCE content filter not workingWe are running Exchange 2003 with SP2 and I'm trying to get the uce content
filter to work. Below is the xml file which I do save as unicode.
I can't get the Inside Elderhealth part to work. I restarted the SMPT server
in Exchange System Center and the SMTP service from Services.
<?xml version="1.0" encoding="UTF-16"?>
<CustomWeightEntries xmlns="http//schemas.microsoft.com/2005/CustomWeight">
<CustomWeightEntry Type="Both" Change="9" Text="viagra"/>
<CustomWeightEntry Type="Both" Change=...
Data Format: how can I re-formatThe spreadsheet that was exported for me to use has the information in
paragraph form:
It is customer ID name and billing info but it is like a long series of
address labels.
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.
Thanks
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...
Wnat to change email address of Public Folder email address with Exchange 2003! Get errorThe HTTP service used by Public Folder is not avialable, possible are that
the Public stores are not mounted and the Information Store service i snot
running.
Id no: c1030af
Exchange System Manager
Used as part of SBS 2K3
Publick folders and information services are started and working properly!
Questions?
1) How to fix
Public stores are not mounted? How?
2)
Fixed with Exchange SP1
"Walt Smith" <walts@yahoo.com> wrote in message
news:z0Nqe.59554$887.53617@tornado.socal.rr.com...
> The HTTP service used by Public Folder is not avialable, possible ...
Access 2007 date function not workingI had a database in Access 2003 that I imported into 2007 and all works well
except the date function in Reports. I have tried to go into reports and
repair by adding a date field, but when I try to open the report and error
box comes up asks for update parameter value for the date. The currrent date
will not display in my reports, just (#name?) is in the date field. You would
think trying to put the current date in a report would be easy.
--
Thanks, Mark
Use this ---
=Date()
--
KARL DEWEY
Build a little - Test a little
"Mark K" wrote:
> I had a database in Access ...
Outlook 20003 stopped workingHi,
As of 3 days ago, my outlook suddenly stopped working.
Nothing had changed on my computer during these days.
This probolems happens on 2 computers I have here, bit
have the same setup and same hardware.
1. My laptop still works, I can login to all my accounts
and get emails into outlook and outlook express, I can
also login to msn messenger. So therefrore this is not an
ISP issue.
2. I dont have a bad header or big attachement on any of
the emails I am trying to download right now. I have just
send some basic plain text messeges test messages. with
outlook its starts to downl...
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
--
sonik
-----------------------------------------------------------------------
sonika's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...
Count invalid data entriesI am using the following macro to identify invalid data entries in
cells with data validation applied.
Sub CheckOrder()
' Application.CommandBars("Formula Auditing").Visible = True
ActiveSheet.CircleInvalid
Sheets("Configuration").CircleInvalid
Sheets("Parts_TakeOff").CircleInvalid
MsgBox ("Check for Red Circled Invalid Data Entries on" & Chr(10) &
" Configuration and Parts_TakeOff Sheets")
End Sub
Is there a way to count the number of invalid data entries (red
circles) and write the number to a particular ce...
Getting row reference numberKindly advise me how to get the row reference number of data which VLOOKUP
function fetches.
Thanks
If you use the MATCH function, instead of the VLOOKUP function, it returns
the row_index of the searched range.
Example:
if you have A, B, C in cells A11:A13
and you use =MATCH("C",A11:A13,1)
that formula will return 3 (because A is the 3rd item in the list.
To get the actual row number, use:
=MATCH("C",A11:A13,1)+10
(because you need to add in the number of rows above cell A11)
Does that help?
***********
Regards,
Ron
"Mahendhra" wrote:
> Kindly ad...
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?
Thanks!
You cannot open an entire database in Design View. Try opening it normally,
selecting a form, and choosing Design View from the V...
Enter month, get the first dateHi,
I want to be able to select the month from the drop down list and once the
month is selected, I want the first date cell to change itself to the first
date of the month selected. For rest of the date cells I have just used the
formula "First date cell + 1"
any help will be appreciated!!
Thanks a lot in advance.
Check your other post.
Gaurav wrote:
>
> Hi,
>
> I want to be able to select the month from the drop down list and once the
> month is selected, I want the first date cell to change itself to the first
> date of the month ...
tab order not workingHi,
I've added about 5 custom fields in the Quote form and defined a tab order
using the tabIndex property for all the fields in the form.
However, while this order works for one section, its not working for the
other section....i checked the source(through view source) on the crm form
and realised that crm is enforcing its own tab order(which is quite
haphazard!) despite the javascript code written on form load...
Any solutions....please help!!
Best option is to work within CRM's constraints. Use sections to set
your tab order. For instance, if you want the tab order to go l...