Rolling excel tables in powerpoint
I'm trying to create a slideshow with one excel table rolling acros
The data will change and needs updating monthly; I want to be able t
paste any new data into the old excel sheet and have the data updat
automatically across the slides.
Is this possible? Does anyone have any advice, pointers as to how to d
Thanks alot in advance,
Message posted from http://www.ExcelForum.com
...extracting data from a pivot table
I have a need to use data from a pivot table on other worksheets in my file.
The problem is that when a pivot table changes the data in the cells do not
update to my other parts of the spreadsheet accurately.
...Need help sorting pivot table
I'm not very experienced with Excel, in particular with Pivot tables, and
would appreciate some help. I have an inherited spreadsheet with a number
of pivot tables in it. The source data for the spreadsheet gets "refilled"
from an Access database, but the rows in the pivot table don't generally get
sorted correctly. The data is in the form of "month year" - e.g. Jan 05,
Feb 05, Mar 05, etc.
I tracked down the source of the data in the spreadsheet, it comes from a
column on another sheet (column V), labeled Month. It's formula seems to
=INDEX(Months,MON...Pivot Table Not Populating Correctly
I run a pivot table with data downloaded from the web but
today for some reason the pivot table will not populate
correctly. After I create the table, I try to drag over
a variable "cost" and it populates every cell as '1' and
rather than labeling the column "cost", it labels
it "count of cost". I can see from the worksheet that it
is taking the data from that the cost is correct but for
some reason the table will not populate with it. Why is
this happening and what can I do to fix it and prevent it
from happening again?
Chris, ...excel to access without linking tables
I'm trying to transfer a huge excel spreadsheet into access and tryin
to do it without having to link the table. Is there any possible wa
this can work? Thanks
Message posted from http://www.ExcelForum.com
Assuming your data is in Database format within Excel, File / Get External Data
and then just follow the import wizard.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
It's easier to beg forgiveness than ask...New information added to table not showing in form
I've added new client information into a table and it doesn't show up in the
corresponding form. Existing client information that was imported into the
table from Excel does show in the form however. What do I need to do?
Thanks in advance for your time!
Check the recordsource of the form to make sure it reads the entire table
and has no filter. Then try entering the data through the form. If it
doesn't show up in the table, you may need to build a better query as a
Arvin Meyer, MCP, MVP
http://www.mvps.org...How to reference 2 datasets within a table in a Reporting services
How can i calculate within my report the movements of two columns
coming from 2 different datasets within a table in a Reporting
services report. The 2 different datasets are MDX queries with exactly
the same number of rows but running over 2 different periods. I just
want to calculate within the report the different between the two
columns data i.e col A - Col B. I am only able to reference one
dataset within the table and for the second dataset, I can only
reference the Sum of this column measure or the First/Last record of
this column measure, but not each data rows of this...Error: Can't clean the following tables:
At the interval of 10 min, event viewer records this Error:
Event Type: Error
Event Source: MSCRMDeletionService
Event Category: None
Event ID: 5895
Error: Can't clean up the following tables: PriceLevel.
I have seen couple of replies about this problem, but they addressed to
different tables. Now, I don't want to mess with SQL, because warranty on
Microsoft CRM server, and I would like to solve it with SQL code that
addresses to this table.
MCT, MCDBA, MCSA, MCP
If y...How to import several csv files into 1 access table?
I have several csv files from 4 distributors and I wish to compile all the
data into one table and export it to csv format to upload on a production sql
all files contain similar field names, such as MFGPartNumber,
ManufacturerID, ManufacturerPartNumber. Would I have to change the field
names manually in the spreadsheets to match my access field name? or is there
a way to have MFGPartNumber=ManufacturerPartNumber in some kind of formula?
I am very new to this and any help would be appreciated.
I'd probably link a CSV file from each of the distributors. Next cr...EXCEL add-on for multi-way tables. Download the OLAP product.
CODEWORK announces version 8.2 of the 3-way TANGRAM OLAP for the
Excel can read TANGRAM hypercubes with an add-on.
3-way TANGRAM is a self-help or survival OLAP - it caters for the
who has no time and budget to install a major OLAP and yet must
respond to requests
in a time-scale of hours.
The product is very lean (8 Mbytes in the minimum config.) and is
installed by file-copy.
Yet it can handle any typical hypercube problem and features several
operations on hypercubes.
The limits of version 8 are: 250 million cells and 15 dimensions for
eac...Opening a window(form) with VBA / storing data in a separate table
I have a third party application (Additional Inventory Fields in the
ActNow series from Hawk Mountain) that currently is accessed from the
Extra menu while in item maintenance. I have added a button to the
item maintenance form and I am trying to figure our what VBA code I
need to put in so that when the user clicks on the button that it
launches the form that is currently accessed via the menu. This is not
currently a VBA form but the window that comes with the application. I
have tried to put an "OnUserChanged" event on the button with a
FormName.Open...Double Messages one rich txt the other plain txt?
I occasionally receive double e-mail messages using Outlook XP SP3
coming through an exchange server. I have looked at the properties of
these messages and I cannot find a common reason why this might be.
Many other messages come in just fine but when the problem occurs I
get 2 of the same messages one in rich text and the other in plain
These messages come from different people all from the same exchange
server mail. Can anyone reason why this happens?
...Protecting Formulas in Tables
In Excel 2007 I have a formatted table, 10 columns wide, in which 5 of the
columns have formulas.
There is a nice feature in Excel 2007 that allows me to type a value in a
cell which is directly beneath the table and the table then expands to
“consume” that value and automatically fills the remaining columns in the
table with, where appropriate, the formulas.
I want to protect the table so that the formulas are not inadvertently
overwritten AND take advantage of this feature.
However, if I lock and hide the cells, then Protect the worksheet, this
feature is disabled.
Ca...Trying to put a pivot table report on an existing sheet causes err
Thanks to Frank Kabel, I can now make great pivot tables. The problem I am having is that I want to write a macro to generate pivot tables, and I want the pivot table report to be saved on a worksheet called "Sum of Open", which is overwritten each time the macro runs.
I have created the sheet named "Sum of Open" which is in the same workbook, but when i try to save it to there ('Sum of Open!'), I get an error:
"Your formula contains and invalid external reference to a worksheet. Verify that the path, workbook, and range name or cell reference are correct, ...How can I convert table and figure cross-references to text?
Using Microsoft Word 2007.
So I have a very large document (300+ pages) that I recently edited to
include list styles and cross-referencing for headings, tables, and figures.
Since parts of the document are often added or removed, this was a necessity
so that the heading, table, and figure fields would auto-update (rather than
having to edit them all manually every time the document was edited).
The problem is, we often publish this document as a .pdf, and the chapter
numbers don't publish in the .pdf bookmarks (i.e. we get "Introduction"
instead of "1.0 In...Outlook adding txt attachment to plain text messages
I'm using Outlook 2000. Recently, it started adding a text
file (*.txt) containing the text of the email. It only
does it when the incoming email is in 'plain text' format.
If it is an 'html' email, it doesn't attach anything. I
haven't changed any of my settings ... I can't find
anywhere to turn it off. I'm not sure if this is the
result of a Windows update or not. Does anyone have any
ideas? Thanks in advance.
the german MVP have answered that question in his=20
Commnunities. =B2It is a bug and it will be gone after a=20
I want to add a table (HR_EMPLOYEE_EXTRA) to the HR Employee Emergency
Contact report. Can this be done?
I looked but could not find a way to do it through Report Writer. I'm sure
there must be a way but it'll take some more looking.
It would be much easier to build a report using SmartList Builder or a
different report writer.
Charles Allen, MVP
"Bob Harrison" wrote:
> I want to add a table (HR_EMPLOYEE_EXTRA) to the HR Employee Emergency
> Contact report. Can this be done?
Content-Transfer-Enco...Pivot Table Formatting
I run WinXP with Excel 2000.
I have a pivot table that uses data that is formatted in non-proportional
fonts (ie: Courier New). The pivot table is also formatted to
non-proportional fonts (Courier New)
I have the pivot table properties set to "Preseve Formatting"
When I close the spreadsheet and open it again, some of the fonts in the
pivot table revert to proportional fonts. I then have to reformat the fonts
back to Courier New
Is there anywaht I can stop this from happening?
For anyone who is interested I seem to have fixed the problem. Originaly I
was o...help merge documents into a master file
Ok, on my local network \\
I have 5 different Excel.xls documents,
in each document there is a single sheet, each one names differently
and of course I know their names...
EAch doc is exactly the same in desigh, has 4 columns, A, B, C, D
A: has Department Name
B: has Date
C: has Employee Name
D: Daily Status
A1:D1 has headers and everything below that starting at
A2:D2 is data...
So, there are 5 different documents, I simply want to merge them all
into a single sheet, keep the headers and paste the data... only select
data filled, ignore bla...Query with two Tables with date filed for Date Range
How do I create a Query using two tables that have dates field to
calculate a value using both the tables for a Date Range. For Example
I have four TABLES- Time Card(TC), PROJECT, TC hours(HOURS), and TC
expenses(EXPENSE). TC contains name of employees and their billing
rates. PROJECT contains Name of Project. HOURS field are TCId,
PROJECTId, Dateworked, and Hours. EXPENSE contains fields TCId,
PROJECTId, Dateexpense, Expense.
I want to build a query that over a Date Range that sums billable
amount=hours worked* billing rate+ expense.
I set the Dateworked >=[forms]![Report Date Range]![Be...Pivot table calculated field
I am using a Pivot table to get the total amount of orders to customer
from a database. I have built the pivot table with a calculated field
since the total amount for each order is missing in the database.
The calculated field = no of products * price per product
For each specific order Excel calculates the row correct.
For the total of each customer and for the pivot table Grand total i
seems as Excel is calculating like this:
(sum of all prices) * (sum of all numbers of products) = Total pe
customer (& Grand total)
Is there a way to change the way Excel calculates the totals?
If ...minimize the file size in a ppt with collections of many pivot tables
is there any way can help me minimise the file (which is a power point)
size for it collects many pivot tables as the content in there. My ppt
file already gets to 221MB which is way unaaceptable for me to work me.
Urgent, could someone please help?!
The pivot tables in your powerpoint file are probably embedded objects. To
save space, highlight the tables in Excel and copy them. Then paste/special
as value elsewhere in the worksheet.
This will produce a simple table. Use this simple table rather than the
pivot table in your powerpoint.
"chermaine" w...how can i combine 3 table
lets say we have 3 storey building in use. At each floor, there are
several type of furnitures. So we have produced 3 seperate table which
has only one field called `furniture name`.
I would like to see furnitures in a single table (query result) which
will have 3 fields (Floor1, Floor2 and Floor3).
If, for example, `Furniture A` exist on only Floor3, Query result will
be null for Floor 1 and Floor2, but Floor3.
Thanks for your support.
I'll urge you to reconsider your design/approach. What you described sounds
like a spreadsheet, not a relational database (i.e. Access).
Instead, consi...Pick and Choose items from a Table
I want to be able to look at a sorted table...and from that choose items I
want to add to my requisition. There will never be more than 150 parts to be
ordered from various vendors.
If I try to extract parts based on just one field i.e. type of material,
this isn't always relevant because more than one type of material may be
ordered from a vendor and not all that are listed. One vendor may have a
better deal than another for a portion of the materials ordered. The table
should then have a mark/indicator somehow that the item has been
ordered/selected so that it doesn't get ordered ag...calculations within a pivot table
I have a simple pivot table with just one column of data that is "gran
totalled" at the bottom. I need to insert a formula that will give m
a 2nd column of data which shows the first column as a % of the total.
fixed 20 20%
can't be fixed 40 40%
to be fixed 30 30%
not tested 10 10%
Grand Total 100 100%
Any help would be much appreciated. Thank
Message posted from http://www.ExcelForum.com
very simple . . when setting up the layout of your pivot
table, drag t...