Reply:

Mac Excel 08 puts "#VALUE!" in all pivot table references when opening an WIN Excel 97 file.
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I recently bought a MacBook Pro 15.4, 3.06GHz, 8GB RAM running Mac Excel 2008 (v12.1.0 080409). When I use Mac Excel 2008 to open excel files that I created in Windows Excel 97 2004, all my pivot tables convert correctly but any REFERENCES to any fields within the pivot table do NOT show the valid values that Excel 97 showed. Instead all refrences have "#VALUE!" in the cell. There is a valid reference startement there but no valid value. How can I fix this? You are a few updates behind: make ...

How To: Link worksheet data to pre-existing chart tables
I have a powerpoint presentation which has all the required excel data charts in it already. Currently to update the charts I need to pick the appropriate data out of seperate excel worksheets and manually input the data to the appropriate charts that generate the charts. How do I link the worksheets with the supporting data directly to the appropriate cells in the excel tables that are used to generate the charts. I would like it so that when new data is entered on the excel worksheets, the appropriate cell data is transferred to the excel tables in the powerpoint lecture that generate...

Pivot Table Calculated field item
Hi, I want to create a calculated field that uses an if to base its calculation results. Therefore i have a field called Site which is a text and another field called materials which is the number of materials. =if(Site="Mexico", materials*300, materials*2000) I have tried this and it doesnt compute based on the Site field or at least the text isnt matching as I have changed the Site to Mexico and it still calculates based on the 2000 amount. Anyone know why? Thanks, Tim Since Site is a text field, the calculated field will evaluate all Sites as zero. So, materials for all...

Extender
Is the Extender Product just for version 8? I looked in Download and couldn't find version 7.5. thanks! -- Doug Extender was not owned by Microsoft before version 8 I believe. You may be able to get it from its original distributor - eOne Business Solutions Website is here - www.eonesolutions.com.au Regards, Colin Stevenson Computer Applications "Doug" <Doug@discussions.microsoft.com> wrote in message news:3213B6B3-7447-493C-ACBD-CCD6C9B07D6C@microsoft.com... > Is the Extender Product just for version 8? I looked in Download and > couldn't find version...

Too few parameters #2
Excel 2002 SP-2 Windows XP Professional SP-2 Does anyone know just what the 'too few parameters' error is in getting external data (I get all my external data from MS Access)? Sometimes I see this error when I have renamed my fields in Acces or if I have a parameter query or something like that, and rightfully so. But sometimes I get this error and I can find no reason why - the query runs fine and the field names havent changed. I used to think it was more 'complicated' queries in Access (i.e. union queries, left joins, etc.), but now excel is acting up on a simple se...

Table cells.
Hello to all my good friends out there. I have created a table with a size of 3.6cm high by 20cm wide. The table itself is 4 cells by 4 cells. If I decide to play about with the size of the individual cells making them higher, wider or shorter etc but then decide that I want them equally distributed in width and/or height again, is there easy way to do this. I cannot seem to do this without having to recreate a new table. The overall table size obviously must stay the same. Your help is and always has been very much appreciated. thanking you in anticipation. <-><-><->&...

Rolling excel tables in powerpoint
Hi, I'm trying to create a slideshow with one excel table rolling acros several slides. 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 this? Thanks alot in advance, Regards, JR -- Message posted from http://www.ExcelForum.com ...

Pivot Table question #6
Hi I have a pivot table with some data. When I put in the one of the fields "Costs" in the data area , excel does a count of the costs or if I go in options( Summary) it gives me choices for Sum, % of and etc. But I just want the values of the costs to show up in the pivot table data area but it does not give me that option .. I dont want any summarizing ( COunt, SUm, Min, Max ..etc) It seems I cannot find how to do that. Please help . Any suggestion is greatly appreciated. Thanks Yusuf. .. Yusuf, Without knowing the specifics, it's hard to tell whether a pivot tabl...

20 Amazing Beautiful Landscape Wallpapers Set 2.exe (7/7)
=ybegin part=7 line=128 size=1593867 name=20 Amazing Beautiful Landscape Wallpapers Set 2.exe =ypart begin=1497601 end=1593867 �C[=@a=}�/��`�5Ҵ�b��,�'���r�?������/��3NV���q���w�3x��`A���7,$D2=J_SOfu�4p�"��Z&N�褜#-n���̷�@��r�/��5�QҬу��� I͠)?{7@�%��[�ym�z��^�~�:���ڑYdkŝ���Dx���@
3��8�p+�"y��$E�ޓeْ2�b<=}STTY]�=@T9W�6����P�%��C��^o�x+1��c�5[O|N�I�KD xb��1Œ�bz$Ӭk�#⺶H���C:��h��,E�?�\?���~��0볈�j�+���T���ay�$���Y%��-��5���<=}�i+�?O�7�#�m�%V�d��9Bc>Qv_;=}�V��w� ��&�S�F6����3���/;^�n�x��=J���>�$��H���WK�\�-�v�+:dyw�=J��A���n�...

Extend PST size after Outlook 2007 upgrade
Looking at a user's Outlook on their home PC. Originally they had Outlook XP, then upgraded to Outlook 2003 and recently to Outlook 2007. Their PST still hits that 2GB limit at times so they periodically archive older emails/folders. My understanding is that there is a 20GB limit on Outlook 2007. Why am I still hitting the 2GB barrier? Does the PST not get converted to the new format when an upgrade is performed on an older PST? What is the best way to convert their PST to the new format so the 2GB limit issue goes away? Thanks. Bill Upgrade installations of Out...

Pivot Table Dates
I'm bringing in data from an external database & creating a Pivot table with grouped dates (Eg months) when this table is copied and the date grouping changed from say months to qtrs it changes the original to qtrs as well is it possible to avoid this happening without creating seperate workbooks Many thanks Neil Thompson You can always create another Pivot table within the same workbook, but not link it to the existing one, You will pay the price in terms of filesize, but it will fix your problem. -- Regards Ken....................... Microsoft MVP - Excel ...

Exmerge Permissions #2
I am only able to use emerge to export emails for some of our mail users, but not all. I followed the direction on Microsoft site for creating a group and giving it send and receive rights to the mailboxes. We are running Exchange 2003 server and I have the latest exmerge utility. Any help would be appreciated. Error opening message store (MSEMS). Verify that the Microsoft Exchange Information Store service is running and that you have the correct permissions to log on. (0x8004011d) With the mailboxes that you are getting errors from can you log into them with either Outlook or OWA?...

Extended Description
We have created many items in HQ, after we do synchronization with the Store we can see some of the Items Extended Description has been truncated to 30-35 Characters in Store and HQ. How can we solve this problem? Hi Rainu, there are 2 thngs which you can do to check this one the log of HQ Server (Sync Log) and the 2nd is to check the sync process using the SQL Profile this is only possible if you have enterprise edition of sql server, I do always use this and find many of my problem solutions. "Rainu Jacob" wrote: > We have created many items in HQ, after we do synchroni...

FRx DAX tables
FRx needs a utility for importing exchange rates into the DAX tables. Or, allow access to these tables so customers could develop there own import utility. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups...

Paid Out Report #2
Looking for a report to show paid outs. I saw some old post but can't open them in my newsreader. Any help would be appreciated. Tom This is a multi-part message in MIME format. ------=_NextPart_000_0C49_01C79D8D.73FDC930 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0C4A_01C79D8D.73FDC930" ------=_NextPart_001_0C4A_01C79D8D.73FDC930 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Tom, Find one attached --=20 Jeff=20 Check Point Software =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3...

Query table not updating as expected
Hi, I have a table concerning Lab Tests which I present using a form. One of the fields in this table is called Test Status where the user can select the status via a combo box. Under this combo I have a label box which shows a summary of the status for the entire table e.g. OK: 10, NOT_OK: 1, NOT_TESTED: 5. When the combo box is changed, I issue a function to change this label. This function does something like this - Private Sub UpdateLabelTestScriptStatus() Dim recordSetTestSuiteStatus As DAO.Recordset Set recordSetTestSuiteStatus = CurrentDb.OpenRecordset("Select * from qryT...

How to show month end balances in a Pivot Table
I have an electronic statement from my broker that lists daily p/l and the acct balance. I have built a pivot table over the data, and the MTD P/L shows fine, but is there a way to get the Pivot Table to show the ending balance for prior months (and the current balance for the current month)? I can only get the PTable to total the balance field, which is not correct. For example: Statement: Date P/L Balance 1/31 -300 10000 2/1 500 10500 2/2 -200 10300 2/3 100 10400 Pivot Table: Month P/L Balance Jan 1500 10000 Feb 400 10400 Thanks! ...

Sync Palm with 2 comptuers
Hi, I have a problem, everytime that I sync my Palm every Birthdays and Anniversary, and all other such event are re-added, so right now I have about 100 reminder of my mother, wife and children birthday, and my anniversary. I think that one of each is enough (at least for me ;-) ). How can I stop this from happening. I'm using the latest Palm Desktop software, and Outlook 2003 on both computer -- Thank you in Advance Merci a l'Avance Martin You don't mention what program you are using to sync with Outlook (Palm conduits, Pocket Mirror, etc.). If using the Palm conduits ...

Extend Volume
Hello, I did an extension of system partition on a server 2008 x64 SP1 which ends with a "wrong parameter" failure at end. Disk management console shows up the new size but within explorer and drive properties window still it has the old size. I did a reboot and disk check (with no errors) - no changes. Eventlog doesn't show any relevant informations. Any help would be appreciated. Hi Thunder, Solution 1 - Delete problem partition - Create new partition - Restore partition data from backup If Solution 1 doesn't work, then Solution 2 - Wipe the disk ...

VB & Pivot Table Refreshes
Hi All (I'm using Excel2000 & VB) I have a workbook of over one hundred sheets, each with at least one query or pivot table, but some have upwards of 20 pivot tables on a sheet. These have to be refreshed in a certain order (not in sheet order), and allowed to complete before going onto the next query or Pivot (no background refreshes), so a VB script seemed the best way to do the job I have been able to generate the script that jumps through the sheets in the appropriate order, determines if a query table and/or pivot exists, and executes the appropriate refresh(es). This works ...

Spelling check #2
Is there anyway to change my Outlook Express spell checking program. It checks all my email for French Spelling and not English spelling and I need the English. Thank you, "Brian" <anonymous@discussions.microsoft.com> wrote in message news:7d0401c3f0f0$f1f8fd70$7d02280a@phx.gbl... > Is there anyway to change my Outlook Express spell > checking program. It checks all my email for French > Spelling and not English spelling and I need the English. > > Thank you, > > This newsgroup is for support of Outlook 97/98/2000/2002/2003 from the Office suite of p...

Pasting Word table into Excel 2000
When I copy a table from Word 2002 and paste it into Excel 2000 for some reason each row in the table ends up occupying two rows i Excel. How can I get the table to paste properly -- Message posted from http://www.ExcelForum.com >-----Original Message----- >When I copy a table from Word 2002 and paste it into Excel 2000 >for some reason each row in the table ends up occupying two rows in >Excel. How can I get the table to paste properly? > > >--- >Message posted from http://www.ExcelForum.com/ > >. >Is the data really in two rows or are the row heighs en...

Resource DLL #2
I tried to create resource dll,with some png files as well as other image files.. how i will get binary data from this resource ? can i use LoadResource and LockResource? how i will get size of one particular binary file?any hep really appreciable Got answer,thanks... zidansoft@gmail.com wrote: > I tried to create resource dll,with some png files as well as other > image files.. > how i will get binary data from this resource ? can i use LoadResource > and LockResource? > how i will get size of one particular binary file?any hep really > appreciable ...

Pivot Table #44
I forgot how to do this: If I have a pivot table that the page headings is of four regions, how can i create four seperate pivot tables, each one being one of the regions? (I know I can do this manually but I know that there is a way to duplicate it automatically to change for the regions) Thanks in advance. -- tkaplan ------------------------------------------------------------------------ tkaplan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=22987 View this thread: http://www.excelforum.com/showthread.php?threadid=387505 Hi tk- How about dragging the...

Extender-Adding Buyer Information to POP Blank Form Header
I have added an extender window to the Buyer Maintenance window, to include email address, phone number, fax number, etc. (Cards>Purchasing>Buyer) I would like to print this information in the Header of the POP Purchase Order Blank form. Can anyone give me some suggestions? Using V9 on SQL thanks! -- Doug There is an article, KB 904575, that has pretty good directions on adding extender fields to a report. But the article has a missing step in it. In Calculated Field 2, there should be a step 3 just like step 3 in Calculated Field 1, which changes the result type to string...