LNSEQNBR in table IV10001
Where does this number come from, or how is it generated?
It is autogenerated and uses 16,384 as a basis for the first line, each
subsequent line is incremented by this number, so line number 2 will be
32,768, and so on. Since most GP transaction entry scrolling windows allow
you to insert rows in between items, the new line item sequence number is
calculated as an average between the previous and the next line item
sequences, i.e., if you were to insert an item in between row 1 and row 2,
the line item sequence is then calculated as (16,384 + 32,768)/2 = 24,576. If
you were to insert ...Publishing Pivot Tables
Is there any other way than to use MS server to publish interactive
pivot tables on the web ?
Im looking for OpenSource solution.
...Item wise balance in Pivot Table #2
I want to get item wise balance in Pivot Table, I tried to enter formula in
pivot table and it works but whenever the new item inserted it does not
and I have to copy formula for each item,
can anyone help me
You need to Refresh the pivot table by clicking the '!' button on the pivot
table toolbar. This will help to display the new item.
> I want to get item wise balance in Pivot Table, I tried to enter formula in
> pivot table and it works but whenever the new item inserted it does not
> and I have ...Query wildcard symbols
Just a heads-up in case this bites you, too.
I migrated an application from Access 2002 to Access 2007.
I have a search form for the users to enter some criteria ... the form
dynamically builds a SQL WHERE clause before opening a "results" form based
on an underlying query that includes all the fields available to search on.
Once in Access 2007 format, the search form opens empty every time?!
When I add selection criteria to the underlying query directly, the result
set is empty every time?!
Oh wait, I'm using the "*" (anything/everything) wildcard character. W...OWA Display Settings
Is there a method to clear the Web Access Display Settings (i.e. Color
Schemes, Preview Pane setup) from the server side of the application for
either a single user or all OWA users? Also, I've had several users report
that if they've attempted to access their OWA mailbox in FireFox, they lose
the way messages are normally displayed in the OWA client where each message
basically has two lines, one line for who it came from and when and the next
line for the subject. After logging to OWA with Firefox, all of the
information is displayed on a single line.
This is on a Windows...How do I display nonprintable characters
We are running Excel 2000 under Windows XP on 2 different PC's.
In a spreadsheet we have imported data from a text file.
The data has included some nonprintable characters which show up as squares
on my PC but as spaces on my colleagues.
We can use the CLEAN function to strip out the squares, but how do we get
them displayed as squares on the second PC, so that we know that they are
Chip Pearson has a very nice addin that will help determine what that
But the only squares that sometimes disappear for me correspond to c...Where free 2 sigma statistical process control chart, free?
where can I download a free statistical process control chart template?
I've this problem, when I drag the fields into the "Data"
area, it will show as "Count of Q1 Results". But what I
actually want is "Sum of Q1 Results". I would have to
manually go to field setting and reconfigure from count
It happens for all the fields I drag into the "Data"
area. Is there any way around this? Thanks.
If there are blank cells, or cells with text, in the column, Excel will
default to the Count function when the field is added to the data area.
If the column contains only numbers, it should default to Sum.
Derrick wr...Conditional Formating: linking to display another cell
Hello, I am trying to make a traffic light with symbols and I've read to 'use
a separate cell for the dropdown choices, with their resulting value linked
into the formatted cell through an IF function, using the character that you
=IF someone enters '1' in B8, THEN display contents of $C$4 (will it display
font and attributes?)
=IF someone enters '2' in B8, THEN display contents of $C$5
=IF someone enters '3' in B8, THEN display contents of $C$6
But I've been reading everywhere and CF is very new to me and I need ...Create Pivot Table Reports
I just finished installing Analysis Cube on the server, everything seemed
working fine until when I try to create the Pivot Table Report
(Tools->Analysis Cubes->Create Pivot Table Reprots). After I called up the
pre-defined 'Definition ID' and click on the Excel icon, a message popped up
saying " The WHTemplate.XLT file was not found."
Anybody have any idea what that is, and how to resolve it??
1.) There are two pieces of software. Did you install both the server
piece, and the client piece?
2.) Is Excel installed on the machine, on which you'r...Constant List
Is there an easy way to return the values of the ChartType
constants? Excel 97 does not seem to list them in help and
I have not been able to find them in google.group
Select xlChartTypes in the Classes pane of the object browser. The
constants are named in the members panel. If you select one, it provides
the numeric equivalent at the bottom of the object browser, e.g.,
Const xlArea = 1
Member of Excel.XlChartType
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
> Is there...Excel --- Physical dimensions of a chart object
Is there a way to know the physical dimensions of a chart object on a
worksheet? I have data in several worksheets and I would like all my
charts to be of the same size (obviously this means that data with a
smaller range of values will be more spread out than data with a larger
range of values).
This is just an example:
n = ActiveSheet.Shapes("Chart 1").Width
m = ActiveSheet.Shapes("Chart 1").Height
MsgBox (n & " BY " & m...How do I add y-axis labeling on the right side of chart?
I'd like to add an axis with same values on the right side of the chart.
You'll need to have at least two series in order to enter a secondary axis.
On one of the series, change the Axis to Secondary axis.
"DavidNHFCU" <DavidNHFCU@discussions.microsoft.com> wrote in message
> I'd like to add an axis with same values on the right side of the chart.
How can I force the y-axis at the bottom of my chart to appear for all 12
months when I only have Jan, Feb and March figures to put in the first thre...excel chart showing movable graph at what point we make a profit
in a business would like to make a chart based on accumulated Earnings &
Profit/Loss for year to date, perhaps movable showing our break even point
and by moving chart to a another earnings figure what profit we should make.
For example put in earnings for YTD Profit/Loss YTD then I can move the
earnings part of the chart to show what our profit would be for a given
If For example if we earn $200 for year so far and profit is $0 but any
amount over that is 18% profit so I can move chart line to say $240 and it
will say what profit I will make.
Hope ...Controlling Gap Width for BAR Chart
I have the following data for example.
A = 2
C = 4
I can create a 2 D Bar chart from this quite easily.
Now If I make the data to
A = 2 , 3
B= 3 , 4
C = 4 , 5
I do want to plot the data on the basis of first two values as
mentioned in the first example, but I want to control the width of the
Bar from the value given after comma. Please help.
On Sat, 24 Feb 2007, in microsoft.public.excel.charting,
Fazi <firstname.lastname@example.org> said:
>I have the following data for example.
>A = 2 , 3
>B= 3 , 4
>C = 4 , 5
>I want to plot the data on the basis of firs...What is the best chart for this....
When I want to compare how each salesperson's sales contributes to Total
Sales, I can use a pie chart. But what do I use when I want to compare how
each salesperson performed against the *average* of total sales?
I am envisioning a vertical bar chart with a horizontal line at the average,
but I need a solution that can be generated by a macro.
Any advice? Thanks in advance.
That's how you would do it, a column chart with a horizontal line. On this web page, I give a
couple techniques to achieve the horizontal line:
http://peltiertech.com/Excel/Charts/AddLine..."Print to Scale" Excel 2007 Charts
In Excel 2003, one could double-click a chart, print, and the chart would
auto-size to fill a page.
I am unable to print my newly-created Excel 2007 charts so they auto-size to
print one-to-a-page (now requires several time-consuming steps for
reformatting titles, axes, etc.).
I do not have a "print to scale" option in my page setup.
Printing to a Ricoh Aficio AP610N. Thanks so much.
I will assume we are talking of an embedded chart (one sitting on a
worksheet) and not a chart sheet.
In Excel 2003 (all earlier) you did not double click, you just single
clicked to...Bar Chart (2D) won't let me 'gap' one bar behind the other?
Operating System: Mac OS X 10.6 (Snow Leopard)
I have a nice, functioning bar chart that has 2 data fields: ACTUAL and BUDGET. <br><br>Actual is on one axis and Budget is on the 2nd axis. <br><br>These charts look nice side by side but I want one bar to be partly behind the other. <br><br>So, I select a data set. <br>
Choose Format Data Series <br>
Overlap... (and no matter what value I choose, I can't overlap)???? <br><br>But, if I can adjust the Gap Width. <br><...Stacked and single column in same chart?
How can I do a chart with a stacked column beside a single column? When I build a stacked column chart, any new source data I add
wants to put it in the same stacked column.
Use one of the links on this page. You need to set up the data so the
single column is in a stacking position with no other columns of data.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> How can I do a chart with a stacked column beside a sing...How a Tooltip can be displayed?
How can a tooltip can be displayed when we hover the mouse over specific
Thanks in advance for your time
I'm not sure about a "tooltip" specifically, but you can click
Insert/Comment from Excel's menu bar and put whatever text you want to
display in the Comment Box that appears and it will be displayed any time
the mouse is over that cell.
Rick (MVP - Excel)
"amateur" <email@example.com> wrote in message
> How can a tooltip c...OWA renders Page cannot be displayed
We are have Exchange 2003 installed on a Windows 2003 Server. We are
allowing access to OWA from outside the network through SSL. We are having a
problem with a few emails giving a page cannot be displayed error when trying
to view them. These same emails can be viewed with no problems from inside
the network(not using SSL).
We have URLScan installed, but I can't see anything in the .ini file that
would cause these emails to not display correctly.
...How can I change primary display for presentation on multiple mon.
I want to hit F5 and have my presentation go to a different monitor. I have
multiple monitors so my laptop display on a classroom screen. Can I change
the default monitor that F5 points to?
In article <5A95BBFC-B291-4A05-9E71-3F094B937ABB@microsoft.com>, Shorebilly
> I want to hit F5 and have my presentation go to a different monitor. I have
> multiple monitors so my laptop display on a classroom screen. Can I change
> the default monitor that F5 points to?
In the Slide Show | Set up show dialog, you can choose the monitor you want to
display slide s...How to control what tabs are displayed in Active Directory Users and Computers
I do not see the value to allow the delegate to change the City, State,
Country, Office. What am I doing wrong. (see info below)
Also is there a way to limit the view of what is shown in Active
Directory users and computers, so the Delegate only sees the General,
Address, Telephone and Organization tabs? I know the step below lock
them out of the other tabs, but there would be less confusion..even if
it is registry hack on that local pc.
Here are the steps I have done so far:
Step 1. Create a Security Group Called 'XYZ' (call it what ever you
Step 2. Open Active Directory User...not enough memory or disk space to display or print the picture after 1st time
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I know this topic has been covered before, but not in the way I get the problem. I can open a document with a math formula or a graphic the FIRST time and it will correctly display. Any changes to the document or any subsequent openings I then get the error message, "not enough memory or disk space to display or print the picture". <br><br>eMac 1.25 Gz 10.4.6, Word 2004 <br><br>Thanks.
One possible cause: You're *way* behind on Tiger -- it's been at 10.4.11 for
...Importing a table from Access query
What is the quickest and easiest way to do the above?
Thanks in advance.
The way I usually do this is run the select query, click on the top-right
box (which selects all records) and use Ctrl+C to copy and Ctrl+V to paste
into my workbook. An alternative is to right-click on the query in the
Database Window and left-click on Export. In the Save As dialog box, select
"Trish" <Trish@discussions.microsoft.com> wrote in message
> What is the quickest and easiest way to do the above?