Can't chart dynamic named range??
I have a named range call TMW with this gnarly formula
When I use GOTO and type TMW it selects the correct cells.
Then I have another named range called TMW_ACTIVE with this formula
It simply takes the same range just over two columns. Again when I use
GOTO and type TMW_ACTIVE it selects the correct cells.
The issue is that I have charts that refer to TMW_ACTIVE and when the
named range was hardcoded with values the charts w...Lookup tables #2
want to use lookup tables as poor man's db.
have about 200 uniquely numbered stores, each time a call comes in we log it
by that number, and each "record" has 11 "fields" or columns. if the list is
sorted in ascending order, how can i use a a vlookup in combo with macro to
go in and key off the unique number and bring all the rows of data back
identified with that unique number to one page?
Stores may have only one "record" and some may 15.
formula would look at the keyed in number...say 101 and go to lu table and
start with 101 and repeat until it reach...Case (in)sensitivity of table names/field names
I would like to work with Microsoft Access 2003 and Windows XP or Windows
Are table names case insensitive?
What about field names?
Thank you very much for your kind help.
Yes, both are case insensitive, as is data. IOW, a search for either peter
or Peter would find you.
Arvin Meyer, MCP, MVP
"peschrader" <peschrader@hREMOVEMEotmail.com> wrote in message
> Hi !
> I would like to work with M...MultiWorkbook Change Event Detection / Spell Checker
Excel 2003 or 2007. Looking to be able to force spell checking whenever any
cell content is is changed. I've been successful on a single workbooks by
adding Spell Check execution on Worksheet_Change.
I'm hoping to take this one step further - make it an 'Add-In' so the check
will run for any workbook. It looks like the Worksheet_Change event only
triggers for the host workbook so an 'Add-in' will not do the job.
Any suggestions to force spell checking on a change for any
workbook/worksheet I modifiy?
The way I would go about this i...How to detect changes in a column?
If I have a table with sales forecast data (columns) like Customer,
Amount and Status, what would be the best way to track changes in this
table so I can compare my forecast week after week?
inomata's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18938
View this thread: http://www.excelforum.com/showthread.php?threadid=493571
...how to insert data in a table
I am creating an access database in which I want to insert data in
already created table.
Vikky <email@example.com> wrote in news:1194124711.012302.269990
> Hi Exprets;
> I am creating an access database in which I want to insert data in
> already created table.
> Kindly help.
Data from where? Do you want to import it from excel, from a text
file, copy it from another table or type it in manually?
PA is y I've altere...Using Named Range for filename
I have a workbook that references various other workbooks on the server.
All the files relate to the current month, so every month we do a
find/replace to update the filenames.
What I would like to do is store the filenames in the workbook and have each
on as a named range.
So instead of the formula =[g:\finance\shared]book1.xls!a2 I can use
I've tried doing this but each time it opens up the file explorer window and
asks for a file.
Thanks in advance
How about just making each one of your stored names as a Hyperlink?
Vaya con Dios,
"...PIVOT TABLE CHARTS
How can I stop a chart reformatting when I refresh a pivot table
This is a known problem with PivotCharts. There's information in the
following MSKB article, which suggests recording a macro as you apply the
XL2000: Changing a PivotChart Removes Series Formatting
Excel FAQ, Tips & Book List
> How can I stop a chart reformatting when I refresh a pivot table
How can I solve this problem if I am using the PivotChart webpart in
Sharepo...Table floating off page in relationships window
Microsoft Access - in my relationships window, one of my tables has gone off
the page and I can't move it down. I scrolled to the top of the page and it
is still cutting the top of the table off so I can't move it down. Any
suggestions on how to rearrange the tables in the relationships window
without physically dragging them around the screen?
There are several methods to fix this issue.
Set your screen res to the next highest setting and then then Maximize your
From Tony and Jeff:
>Could you <tab> to the offending table/window? If so, and ...detect and repair
my outlook 2002 had some hyperlink problems which were
corrected when i used the 'detect and repair' option in
help. now i have lost my addresses and all the e-mail
that was in my inbox. How do i recover these items?
Check this page for all you need to know:
Ben M. Schorr, OneNote-MVP
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"Mark Conner" <firstname.lastname@example.org> wrote ...pivot table: create worksheetsheet using pivot table
While working in a pivot table, I accidentally created a new worksheet in my
file with isolated data from the report e.g. pivot table shows all days of
the month with totals for each deposit account... my 'accident' created a
sheet with all the data for a single date. It turns out, this would be a
useful tool for my manager, but we cannot reproduce my accident. My mouse
was on the blitz and after a few solo selections the new worksheet appeared.
Does anyone know how to do this (intentionally)?
...Pivot Tables #5
I am having trouble with pivot tables. Need to create a pivottable that
summarizes Total amount of orders by quarter. I have these columns company
name,country,orderdate, sales rep,shipper, category, product name, unitprice,
quantity,discount%,freight, totalamount. I was sure I just put total sales
and the order date in but I cant get it to do this in quarters. I am taking
a class that the teacher is of no help.
Too old to be in college
Right-Click on the OrderDate heading in the Pivot Table
....Select: Group and Show Detail
....Select: Quar...Embdded objects
I have a publisher file and I have embedded excel graphs into it
I have many graphs but at least one graph I have to double click
for the graph to show correctly.
When I open the publisher file and try to print it is using the microsoft
Office document image writer printer. My system default printer is my
How can I fix these 2 errors thanks
...fine rotation of an object ?
hi where , if it exists . Is " fine rotate " command for a shape ? i want to
be able to enter the exact degrees - i can always find it in publisher , but
in visio it seems absent
YRS - AJ
Hi Tuscon International Airport!
Try showing the Size & Position Anchor window:
- View > Size & Position
- Enter a value in the Angle cell
Also, when rotating using the mouse, the further you go from the rotation
point, the finer the rotation angle. Ie: when you're close, you get
10-degree increments, when further out, perhaps 0.1-degree increments. Watch
the status ...Pivot Tables
Is there a way to use pivot tables in Excel to accomplish the same result as
an MS-Access process to "join" two tables on matching fields? For example,
I have one range of data that contains employee time card information that
includes a costing code for each time entry. I have a separate data range
that contains, for each costing code, one or more records containing
percentages that are used to allocate labor to specific business units. The
desired result is a table or data range that contains all of the records from
the time card range and all matching record...Array range error question
When i try to redim my array i get an out of range error. can someone tel me
Cells A1..A10 are filled with strings. thanks much
Dim names_array() As Variant 'dynmanic
Dim j As Long
ReDim names_array(5, 1)
j = 0
For i = 1 To 10
names_array(j, 0) = ActiveCell.Value
names_array(j, 1) = ActiveCell.Address
arraylimitFirst = UBound(names_array, 1) 'returns current dimension of 1st
array limit, init = 5
If j >= arraylimitFirst Then
ReDim Preserve names_array(10, 1) ' << RANGE ERROR ...Duplicate detection detecting inactive records?
Is there any way to configure duplicate detection to not look at inactive
records? I can't find any way to set this on the rules.
I'm trying to do a function who delete all the row of a range I pass is
argument and will copy them to an other sheet. Here is my function :
Function RangeToDelete(ToBeDelete As Range, SheetsNameCopy As String)
If WorksheetFunction.CountBlank(ToBeDelete) = 0 Then
I want to check if the range is empty first so I don't have an error
cause I can't delete something that is empty. But this function doesn't
work since the CountBlank is not workin...How to Detect and prevent CD burn
How can i stop to CD burn of any file from my system to CD.How to detect the
event of CD burn and how can i stop CD burn.Basically i want to secure my
file from CD burn.
plz reply soon.
> How can i stop to CD burn of any file from my system to CD.How to detect the
> event of CD burn and how can i stop CD burn.Basically i want to secure my
> file from CD burn.
You can restrict access to a file only to a certain users through
NT/win200 access privileges. You can encrypt a file and therefore
restrict access to a file on...Re : Excel Range of Values Amidst Characteristic Transitions
Re : Excel Range of Values Amidst Characteristic Transitions
Enter an Excel worksheet ; now that the tabulation is prepared for
(preferential) presentation, Column A is shown as follows :-
03 <A Blank Row>
05 <A Blank Row>
06 <A Blank Row>
08 <A Blank Row>
11 <A Blank Row>
14 <A Blank Row>
15 <A Blank Row>
16 <A Blank Row>
18 <A Blank Row>
20 <A Blank Row>
22 <A Blank Row>
24 <A Blank Row>
25 ...Pivot Table macro to set print area and print details of drill down data
I have created a pivot table from a set of data which the user can select
parameters on to specialise the data and then double-click any total to
drill down to the underlying data. I am trying to design it so that a user
will see all of the underlying data but when they print it it will only
print the leftmost 12 columns. I thought I may be able to do this by
creating a macro that captures the double click event, create the drill down
data sheet and then to record the set print area and header footer
information etc. and then stop recording. Then put this macro in users
workbooks so th...My Computer not detecting my external harddrive
I have a IDE hard drive with USB casing and connected to my USB port.
The problem is the hard drive partitions are not shown up in My computer.
But My Computer->Manage->Storage->Disk management shows the hard drive with
3 partitions and all the three are healthy.I know there are a few bad sectors.
I am sure I have not made any changes in registry that prevents drives from
Please help me.
Do the partitions have drive letters assigned?
> I have a IDE hard drive with USB casing and connected to my USB port.
> The problem is the ha...Data analysis
FYI - I know Pivot Tables should work for this, but I've tried and they just
don't work well with everything else in the worksheet so I'm hoping for
I have a list of our accounts and products they sell. I've put the accounts
into a drop down box so one may be selected to populate a chart, but now I
need to add another drop down box to select one item from all of the products
the account sells. But I'm stuck on this part - each item has five facts:
dollar sales, pound sales, unit sales, cost, price so the product code shows
up five times and I ..."Runtime Error: Subscript Out of Range" #2
But it opens the workbook first, copies, THEN gives me the runtime
bludovico's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14805
View this thread: http://www.excelforum.com/showthread.php?threadid=265437
supply the code then.
"bludovico" <email@example.com> wrote in message
> But it opens the workbook first, copies, THEN gives me the runtime
&...GUID is not detected by server .& cannot go offline...SFO.
why is the server not detecting the GUID attached to the subject line of
email...what could be the problem...
Also i am not able to go offline ..I get an error Domain canot be contacted
or does not exist...
Thanks a million.