Pivot Table Can Not Add Field to Row

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Frontpage Client
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Navigation Bar I am using FrontPage 2003 I am trying to create a navigation bar on a page that contains several tables. I want the bar to go to individual tables that are located on the same page as the navigation bar. I went through MS Tutorial on Custom Bars. But after I created the first link it would not let me created any additional links to the same page. When I went to test the first link it did not take me to a table because it is linked to the page. I did bookmark my tables but how do I get the link to the bookmarks? Can anyone help me or at least point me to somewhere I can get some help? Aurora Tag: Pivot Table Can Not Add Field to Row Tag: 911156
  - 2
    - Displaying swf files I read the archives on this subject but still have some questions. I work in support stafffor Univ. of Delaware and inherited responsibility to maintain current Web site without having any real training in that area so I am in OTJT. We have Windows 2003 Server and FP 2003. The sub Website in question is: http://www.rec.udel.edu/poultryextension/new_page_3.htm I have had our IT dept in main campus convert 6 PowerPoints to swf files. On my PC XP (not server) where I have Flash Player, Shockwave and Adobe CS3, I was not able to view the final swf files. They came to me with that generic program icon. Only in Bridge could I view them. Now, on our server, with FP 2003 I want to provide visitors with the capability to easilty view these six presentations. There is no Adobe software other than reader installed on the Server. Right now, you will see the six presentations as PowerPoints but many folks cannot view these properly which is why we requested flash swf files in the first place. Now that I have the swf - what do I need to do with them? Will viewers need to have flash plyer or shockwave player to view? Is there a way to download the required player automatically or will I need to provide the install link separately. Why could I not see them on my own computer. We are at a remote campus location, 2 hrs away from main campus and don't have instant support from our IT. Tag: Pivot Table Can Not Add Field to Row Tag: 911153
  - 3
    - Syntax for DMax I am using access 2003. I have a form with a text field. This statement works fine but it returns the date from the first record and I need the date from the last record. Do I use DMax and if so where would I position it in this statement ? =DLookUp("[Date]","[attendance_clock_in]","[StudentID] = " & [Employee ID]) Tag: Pivot Table Can Not Add Field to Row Tag: 911147
  - 4
    - web site Development Hello, I only intend to "display" data on the website that currently resdes on my excel file. i.e. users will not download the data displayed on the website but only read it as displayed. Hence I was curious to know if the Excel file can still be used as a database(using ODBC drivers then using database result wizard) Please review and advise if it is okay to use Excel to only "display" data and how to do that. I would be updating the Excel fle daily and hence the data on the website should change daily as well. I asked this question regarding excel as a database but everbody suggetsted me to use access database. I mean Convert excel to access then import it into frontpage. I have another question is i am doing all worok in on my computer. This is the first time i am building my website whcin i imp for me. what should i do for the following message. "This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network"....it is dispying only column names not records can u plz tell me detailed steps to solve this problems. I purchased the domain from microsoft. I have 500Mb free space. is it possible to run my file there and see the result. Thank you in advance! Tag: Pivot Table Can Not Add Field to Row Tag: 911146
  - 5
    - Reinstalling Frontpage 2002 I have a new computer, OS Microsoft XP. I need to reinstall FrontPage 2002. I cannot get it to accept product key on the back of the CD case; the message either says the product key is wrong (it's the one PRINTED on the case) or it cannot find the CD if I pursue the options. Is the 2002 version not compatible with XP? I've never run into this problem before, where the product key is not accepted. Any help appreciated. Tag: Pivot Table Can Not Add Field to Row Tag: 911144
  - 6
    - link bar problems I seem to be having trouble getting my link bar to work. I am using Frontpage 2003. When i open my website using frontpage the link bar isn't there, the only thing that appears is the "+ add link". which means the link bar is actually there but why can't i see the tabs. Then when i upload it the text appears but not the colourful style tabs. I changed the style of the link bar and it appeared in my frontpage but then i saved and closed the page and when i reopened the page, it was gone again. Can anyone help me with this? Tag: Pivot Table Can Not Add Field to Row Tag: 911139
  - 7
    - Search Function The default Search Web Page Template in Front Page returns links for htm or html documents in my web. What I need to do is return pdf's and Word Docs. How can I accomplish that? Tag: Pivot Table Can Not Add Field to Row Tag: 911137
  - 8
    - countdown timer Is there a way to create a countdown timer in Frontpage? Tag: Pivot Table Can Not Add Field to Row Tag: 911129
  - 9
    - How do I create a landing page out of a new website home page? I've created a website. I want to make my website home page the landing page when I open my HP computer? How do I do this? Thx. Tag: Pivot Table Can Not Add Field to Row Tag: 911118
  - 10
    - site map font size? I use the automatic FP site map generator. I can change the font size of the title but not of the rest of the listing. Is there any way to do so? http://www.scienceclassroom.com/mrsdz/sitemap.htm Tag: Pivot Table Can Not Add Field to Row Tag: 911115
  - 11
    - FrontPage 2002 - Access filter using date of birth I have inserted drop-down dialog boxes for Month, Day, and Year (down to 1909). To enter my site the customer must enter his/her birthdate, and click the "Continue" (Submit) button. How do I configure the "Continue" (Submit) button properties so that it verifies that the birthdate entered is more than 18 years of date. Thanks for your help. -- PEdonnaTER Healthy Living, Healthy Diet, Wellness Tag: Pivot Table Can Not Add Field to Row Tag: 911114
  - 12
    - Cannot renumber or bullet a document - icons are grayed out I am working with in Word 2003. Track Changes has been used on this document. Several people have modified/updated this document. I am now trying to renumber a list within a table, but the Bullets/numbering icon is grayed out and I appear to not have permission to update the numbering. Why is this and how can i fix this? Tag: Pivot Table Can Not Add Field to Row Tag: 911111
  - 13
    - Forms I need to make a form which will collect a information from it. We have a church website using FP2003. We make offers for various informaton such as articles, CD's and DVD's. Each would have to have its own form and title. Right now the form is just a text email and I have to enter the name, address and etc. into an Excel spread sheet when the emails are received. What I would like to have done is have that information automatically placed into a form which I can use to print up the mailing labels for each request. Can anyone help with this? Or can build this form for our church. Tks, Jeff Tag: Pivot Table Can Not Add Field to Row Tag: 911110
  - 14
    - Custom Error Page I'm using FP2000 with FP extensions installed on the server. I'm managing a website that has frequent page additions and deletions, and the site could really benefit from a custom 404 page. My server's knowledgebase has instructions for creating a custom error page by editing the .htaccess file, but warns against doing so when using FP, since this will corrupt the configuration files. Can anyone suggest another approach or a workaround that will allow me to have a custom 404 page? Thanks for your help. JW Tag: Pivot Table Can Not Add Field to Row Tag: 911109
  - 15
    - Cheap Discount Prada Chanel LV Chloe Hermes Guess Dior Wallet, Fendi Cheap Discount Prada Chanel LV Chloe Hermes Guess Dior Wallet, Fendi Wallet, Coach Purse, Juicy Purse, Miumiu G U C C I handbags Leather bags Discount Miumiu Leather bags MiuMiu coffee miu miu miu miu woven hobo handbags Designer Handbags http://luxury911.mayiweb.com Tag: Pivot Table Can Not Add Field to Row Tag: 911105
  - 16
    - Need java variable in an email form I have a java function that returns a value in the variable "name". How can I get this value into a form field so that I can include it in the emailed form results? I don't need it as an initial value in a form field; I just need it included in the email that's sent back. I have tried making a hidden form field with the name "test" and the value "<%=name%>" but it's not getting passed. Tag: Pivot Table Can Not Add Field to Row Tag: 911102
  - 17
    - Layout of website is not flawless in Firefox and Netscappe My website looks fine in IE 7, but not in Firefox and Netscape. I use a DWT, and if I remember correctly, I designed the site with a layout table with "Corner, Header, Left and Body." I split the body to get two columns. I added header, footer and applied corners and shadows. In Firefox and Netscape, the headers and footers of some pages are not consistent. What can I do to make the website look good for all browsers? Also, I don't know what happened, but when I go back to my DWT, all the options in the task pane to modify the layout are grayed out and not active. It looks a if for some reason I cannot do any changes! I use FP 2003, and the URL is www.developserenity.com Any ideas are greatly appreciated, Monika Tag: Pivot Table Can Not Add Field to Row Tag: 911099
  - 18
    - Excel-Frontpage Hello, I only intend to "display" data on the website that currently resdes on my excel file. i.e. users will not download the data displayed on the website but only read it as displayed. Hence I was curious to know if the Excel file can still be used as a database. I am keen on using Excel instead of Access since I know Excel and not much of Access and moreover my data is in Excel. Please review and advise if it is okay to use Excel to only "display" data and how to do that. I would be updating the Excel fle daily and hence the data on the website should change daily as well. Thank you in advance! Tag: Pivot Table Can Not Add Field to Row Tag: 911098
  - 19
    - Abnormal Program Termination FrontPage 2003 Program installed. Serial number entered. Installation completed. When I click to start the program, a window appears with the following error message. Any help gratefully accepted. Eric. ********** Microsoft Visual C++ debug Library Debug error! Program: I:\Program Files\Microsoft Office\Office11\FRONTPG.EXE abnormal program termination (Press Retry to debug the application) ed. note: Nothing debugs :-( Tag: Pivot Table Can Not Add Field to Row Tag: 911096
  - 20
    - error message "httpd.conf" this is a new problem - tried to post my website changes and now I keep getting an error message unable to access "httpd.conf" what does this mean. Have not had this problem before. -- newbie confusion Tag: Pivot Table Can Not Add Field to Row Tag: 911094
  - 21
    - Zooming View in FrontPage Is there any way to zoom the view the design window in FrontPage? Right now, I am using the Magnifier, which is a kludgy work-around. The same problem exists in MS Access when trying to design forms. Tag: Pivot Table Can Not Add Field to Row Tag: 911089
  - 22
    - <body> tag duplicate For some reason Frontpage adds a second <body> tag in the code of my Frontpage. What happens is that the body of the webpage is duplicated. When I create a page, I have to go to the code page and delete the duplicate <body> tag to prevent that. If I open a previous page that has already been created, I have to delete the extra <body> tag before saving. If I don't delete the extra <body> tag it will duplicate each time I open it. If I open it for editing four times, I will have 4 <body> tags and when it is published, I will have four pages of the same thing and you won't be able to read it. I have searched for a solution to this but haven't found one. Microsoft talks about a duplicate <body> tag but states it ignores the second one but it doesn't ignore it. It must be in the template in Frontpage but haven't figured out how to fix this. Any ideas? Thanks for your help in advance. Windows XP Professional SP2 with all updates (except for SP3 due to known errors) Office 2003 with all updates Frontpage 2003 with all updates. Pentium 4 home built 2 gigs of memory two 75 gig raptors Raid striped. -- Jesse Tag: Pivot Table Can Not Add Field to Row Tag: 911086
  - 23
    - TORONTO need FP 2002 help $$$ Hello I've created a Webpage (only one page so far) to raise money for my dog dieing of Cancer to help pay for her treatments but I need to complete it ASAP. I need about an hour or 2 of someone time to help me with a few things only related to the webpage (not hosting). I have very little money but I can pay for the hour and a half maybe 2, $30. I need someone with Advanced knowledge and good English. I can meet somewhere public with my laptop like a coffee shop. I live near Bathurst & St Clair. Please email me if you can help Thanks Sharon Tag: Pivot Table Can Not Add Field to Row Tag: 911085
  - 24
    - HELP PLEASE with .EPS &Frontpage 2002 I try to put up a webpage to raise money for my dog that is dying of Cancer. I'm hitting so many walls. I'm trying to insert an irregular shaped graphic in to my Webpage in FP 2002. It is an EPS file crested in Corel Photo Paint 9. In FrontPage it just shows as a red X (broken graphic) I tried viewing it in preview and browser but nothing. Can I insert an irregular shaped graphic on my webpage it is a cut out of a tree. ANY HELP WOULD BE APPRECIATED Thanks Sharon Tag: Pivot Table Can Not Add Field to Row Tag: 911084
  - 25
    - HTML graphic not viewable on webpage When I added HTML code with a graphic to Frontpage, it shows up on Frontpage, but not on the actual website. (There is only a box with an x in it like there should be a picture there.) How do I get it to show up on the actual website?? Tag: Pivot Table Can Not Add Field to Row Tag: 911081
- Next
  - 1
    - Attn!!! Job Title: Senior PEGA PRPC Consultant at New York / New Hi: This is Pradeep from Charter Global Inc.,. Here I got an urgent requirement from the hiring manager of our world class client who is looking for a Senior PEGA PRPC Consultant at New York / New Jersey. Please check it out and forward your consultant=92s updated resume with following details to me ASAP. Full Name: Email: Contact: Cell/Home Availability: Present Location: Visa Status: Job Title: Senior PEGA PRPC Consultant Location: New York / New Jersey Duration: Long Term Experience: 8+ Years Overall, 3+ in PEGA PRPC Responsibilities: Perform the role of Business Advisor to a large account Participate in new business deals playing a key role in solutioning Oversee delivery of multiple large Pega Program initiatives Own up creation of Pega best practices, guardrails and reusable assets in the organization Mentor lead system architects and technical architects within the domain Thanks & Regards Pradeep Nadendla Technical Resource Manager Charter Global Inc. Voice : 866-570-1818 Ext.333 | Fax:770-206-2327 | Email: npradeep@charterglobal.com | Website: www.charterglobal.com ___________________________________________________________________________= ______________________________________________________________ NOTICE: This e-mail message and all attachments transmitted with it may contain legally privileged and confidential information intended solely for the use of the addressee. If the reader of this message is not the intended recipient, you are hereby notified that any reading, dissemination, distribution, copying, or other use of this message or its attachments is strictly prohibited. If you have received this message in error, please notify the sender immediately by electronic mail (postmaster@charterglobal.com), and delete this message and all copies and backups thereof. Thank you. ___________________________________________________________________________= ___________________________________________________________________________= ______=AD=AD=AD=AD=AD=AD=AD=AD _____ Tag: Pivot Table Can Not Add Field to Row Tag: 911080
  - 2
    - Navigation Changes FP 2003 The production site's navigation is screwed up becasue someone else changed it. The one on my office computer is OK. Is there a file I can ftp to the production site that would change the navigation without having to sync, etc? Thanks. Tag: Pivot Table Can Not Add Field to Row Tag: 911073
  - 3
    - Question abt access Db cc frontpage *762008 Dear All, I have a product-database with relevant product-info including linked Pics and I would like to know if it,s possible to put all that info INCLUDING the PICTURES on my internetpage via a link ,so that the information does not have to be updated all the time because its linked and changes made in the DB automatically get updated on the website! Is this possible using Frontpage,by the way the pictures are stored as OLE objects. Thanks in advance! Tag: Pivot Table Can Not Add Field to Row Tag: 911071
  - 4
    - Uploading video with frontpage I have use frontpage 2003 to make my website. I want to upload a video to the site, but it doesnÂ´t show. Why? The video is in the right folder. The html kode is following: <img border="0" dynsrc="../../../Videos/FYS%20juli%202008_0002.wmv" start="fileopen" width="192" height="219"> Have you any suggestions?. Tag: Pivot Table Can Not Add Field to Row Tag: 911066
  - 5
    - 0x80004005 error I am designing my web site usin front page using excel db...When i run databbse result wizard ...i am getting this error...plz tell me how to solve this error?? Server error: Unable to connect to a database from the Web server using the connection string 'DSN=bbbb;DRIVER={Microsoft Excel Driver (*.xls)}'. The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured. ------------------------------------------------------- [Microsoft][ODBC Excel Driver] External table is not in the expected format. Source: Microsoft OLE DB Provider for ODBC Drivers Number: -2147467259 (0x80004005) thanks in advance Tag: Pivot Table Can Not Add Field to Row Tag: 911061
  - 6
    - Disable picture manager as editor for thumbnails in fontpage 200 I have created thumbnails and when using ctrl and click as instructed picture manage takes over the pictures which have already been edited in Paintshop Pro before being put onto website. Tag: Pivot Table Can Not Add Field to Row Tag: 911060
  - 7
    - Just published and all the internal links are not working! I have just published my website (FP 2003). But what a disappointment! All my internal links (and the links in the jump - to menus) are not working! What did I do wrong? Here is the web address: www.developserenity.com Please help! Monika Tag: Pivot Table Can Not Add Field to Row Tag: 911058
  - 8
    - Default 'Open Web' view My computer was worked on and now my default views in FrontPage changed. I don't know what was changed!! I used to click the 'Open Web' toolbar button and my sites would be listed in the 'Open' window. Now, I click the 'Open Web' toolbar button (or menu option) and one site and contents are listed; I have to click the 'My Network Places' button to see my sites listed in the 'Open' window. How do I default it back to my sites listed in the 'Open' window again? Tag: Pivot Table Can Not Add Field to Row Tag: 911055
  - 9
    - Validation Function How do i allow users to choose multiple entries from a list? -- Morry Tag: Pivot Table Can Not Add Field to Row Tag: 911050
  - 10
    - Browse Folder I'm setting up a website on our web server so you can view or browse some folders. When I go to the site and browse the folders, I see the following: Date File Size File Name How can I change these? Maybe just show the File Name. This is a IIS 5 server. Thanks. Tag: Pivot Table Can Not Add Field to Row Tag: 911046
  - 11
    - Frontpage 2003 editing trouble I use Frontpage 2003 and currently have two websites. I do all of my editing online in real time. I have had one site up a running for six years and the other site is new. I went online to edit the new site and I noticed that it did not prompt me for a username and password, it just went into editing mode but when there I could not access the navigation structure. So I decided to check my old site and It did ask for a username and password but it would not take my information. So I pressed the cancel button and it did let me in to edit the site but I cannot access the navigation structure in this site either. Any instruction on what may be wrong would be appreciated. thank you in advance. Tag: Pivot Table Can Not Add Field to Row Tag: 911029
  - 12
    - Visual Web Developer 2005/2008 Express Does anyone know if there is a discussion group set up for Visual Web Developer 2005/2008 Express Edition -- Thanks for your assistance Tag: Pivot Table Can Not Add Field to Row Tag: 911026
  - 13
    - Inserting a layer into a cell I want to insert a layer into a cell in a table and make the positon relative to the coordinates of the cell; e.g. like when you insert a layer into another layer, you can make the Left and Top position 0, which corresponds to the coordinates of its parent layer. How do I do this? Tag: Pivot Table Can Not Add Field to Row Tag: 911025
  - 14
    - how to open a remote web site from a different computer how to open a remote web site from a different computer to edit it Tag: Pivot Table Can Not Add Field to Row Tag: 911019
  - 15
    - Viewing Full page in browser. I cannot view the full web page when I preview the page in my browser. Any ideas? Tag: Pivot Table Can Not Add Field to Row Tag: 911018
  - 16
    - Editable Content with DWTs Hello, I've been charged with overhauling an existing and multi-layered corporate website (and am a Finance person, not in IT). I found DWTs to, thus far, be the most useful way to imprint a uniform format to all these sub-pages; however, in my DWT I've created a box for editable content in all applied-to pages, yet the editable content box seems to "shift" on its own to arbitrary locations on the applied-to webpage (after assigning the body1 to the editable content region). Any thoughts on how to anchor the position of the editable content box so that it will stay in the same page on all applied-to webpages? Thanks in advance for your help. Tag: Pivot Table Can Not Add Field to Row Tag: 911017
  - 17
    - No text in Firefox 3 Having been maintaining a website (www.sharpquip.com) and was fine, but now cannot see text on back pages in FF3. Any suggestions? Tag: Pivot Table Can Not Add Field to Row Tag: 911016
  - 18
    - how do I put home link in site that doesn't open all frames again. When I put a link somewhere in the web site to return to the home page, it reopens all the frames again in the main fram. Any ideas on how to just open up main / index without duplicating frames again? Tag: Pivot Table Can Not Add Field to Row Tag: 911015
  - 19
    - Front page Can we use excel as db src using ODBC connecions in FP. i asked this que many times but everybiday is saying me us access as data src but i can't use acess for my web site. I am building simple web site for that i need to display my ecxel file but i am going to update my web site everyday i future/ what are the diffieret option to displaly excel file in FP sp that i can update it in future everyday. thanks in advance.... Tag: Pivot Table Can Not Add Field to Row Tag: 911012
  - 20
    - Site Problem Our site is currently only housed on our web service provider's server. We have no local files at all. Obviously, this is a big issue that I need to correct. However, I'm not having any luck figuring out how to get my web files stored locally and changing the site to only publish files I select, rather than publishing them upon saving. I'm using FrontPage 2000 and the url is www.neha.org. Any help you can provide is appreciated! Tag: Pivot Table Can Not Add Field to Row Tag: 911009
  - 21
    - Frontpage--Excel as DB I posted my questions regarding databse connectivity in FP using excel. All are saying me not to use excel ...Use access as Db souce but my file is in excel and i can't use access for that. If i can plz tell me how to do that. what are the ways to disply excel file in FP. i need to update that file in futuer at every day. thanks in advance Tag: Pivot Table Can Not Add Field to Row Tag: 911008
  - 22
    - forms help Hi I am using frontpage 2003 to create forms, and when I hit the submit button I do not get the confirmation page, rather I get the page that lives it the vti folder. /_vti_bin/shtml.dll/leapaward/form.htm When I fill out this page, then it brings up the confirmation page-- can anyone tell me why, or what the problem is?? Thank you Tag: Pivot Table Can Not Add Field to Row Tag: 911004
  - 23
    - Working with Database in frontpage I am building my website using frontpage . For that i am using my excel file as database. I have created excel database through ODBC first i created system DSN I used database result wizard for that(insert->db->result) my excel file is coming with all column names witth no records. When i save that web page it is saving with ASP extension and preview it in preview option i am getting this meeage below columns. Database Results regions will not preview unless this page is fetched from a Web server with a web browser. The following table row will repeat once for every record returned by the query I am building web site first time...I am not sure wherther i am doing right things or not. i don't have web server..i am previwing my page in preview option..should i run it on web server????? for that what should i do? ...Anybody plz tell me what are the steps for that.. do u know abt any web site for frontpage which will help me to build web site thanks in advance Tag: Pivot Table Can Not Add Field to Row Tag: 911003
  - 24
    - Shared Border Gone I had had a shared border on my web site, as I went to create a new page, I created one without the border and it got rid of the shared border over the whole website,it auto published for some reason and now its completely gone!!Does anyone know how I can get my shared border back that has all my links? Tag: Pivot Table Can Not Add Field to Row Tag: 910999
  - 25
    - Website and Database methodology question Hi I'm building a company Website using Frontpage 2003 but no very little about web development. The site will be hosted by our ISP. At our office we run Microsoft Small Business Server 2003 Premium which includes SQL Server. We want the website to have some content which is restricted to registered users so need a log on procedure and also eventually want to develop on-line ordering for our customers. My question is concerning whether the user/password data and the more extensive customer/item/price data (Excel/Access MDB/SQL Server Database info or whatever) would normally reside on the ISP's server with the Website or is it normal to link the website to data stored somewhere else e.g. On our office SBS Server. Is there a norm for this ? If the Data needs to reside with the website, how would it be maintained? Many thanks Tag: Pivot Table Can Not Add Field to Row Tag: 910998

The Field (column on the work sheet) is text. It is "=left(A2,3)".
I have tried as a caluclated field. I tried Copy, Paste Special, Value.
I can use the field as a filter or column but not as a row.
"The field you are moving cannot be placed in the Pivot Table area."

Top

Re: Pivot Table Can Not Add Field to Row by Tom

Tom
Fri Jul 18 16:24:28 CDT 2008

If this is an Excel question, you're in the wrong newsgroup. This is for
FrontPage.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
"You're a daisy if you do!"
---
FrontPage Support:
http://www.frontpagemvps.com/
===
"Michael" <Michael@discussions.microsoft.com> wrote in message
news:C4A47C4E-98AD-4CEC-9E6D-4344C9EE6C7D@microsoft.com...
: The Field (column on the work sheet) is text. It is "=left(A2,3)".
: I have tried as a caluclated field. I tried Copy, Paste Special, Value.
: I can use the field as a filter or column but not as a row.
: "The field you are moving cannot be placed in the Pivot Table area."

Top