Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    pivot table created subfolder (Excel 2002 SP 2)

    Hi,

    I tried a search on this forum but couldn't find anything. If someone can suggest what search criteria to use, if this problem has been discussed before, then I'll do my own search.

    Yesterday when working with a dataset, I created several pivot tables in one file. I saved the file then went home. When I came in this morning, I noticed that a subfolder had been created in the directory where I stored the file. I opened the file and created a further pivot table. When I clicked on the worksheet of one of the pivot tables I created yesterday and tried to change the layout a window popped up that said " This pivot table report is not valid".

    The subfolder contains
    cachedata.xml
    editdata.mso
    filelist.xml
    sheet001.htm (through to sheet007)
    stylesheet.css
    tabstrip.htm

    When I tried to open one of the Excel files in the folder it said the file was already open and if I continued it could corrupt my data.

    I also noticed that one other spreadsheet in the directory also had a subfolder created.

    This has never happened to me before and I am wondering if it has to do with my excel data files. The files in the folder are extracts from an online database that exports the data to excel. The data is from a new system that has been implemented in my workplace and I need to start working with the data and setting up reports for other people.

    Thanks for any help with this problem

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: pivot table created subfolder (Excel 2002 SP 2)

    Could it be that the wokrbook has been created in Excel 2007 beta?

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: pivot table created subfolder (Excel 2002 SP 2)

    Problem solved.

    I was continuing working with the file and when I tried to save it, a window appeared that said some feature were incompatible with Webpage format and I should save as Excel.

    I don't know how it got into that format as I have no idea what that format is. I wonder if it is related to the download of data from the web? The file has an .xls extension.

    I still can't access or change the earlier pivot tables in the file, but any of the pivot tables I created today are fine.
    I will just have to ensure that none of my files get into that format again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •