locked
MOSS is changing excel file pivot datasouce is changing RRS feed

  • Question

  • I have one excel file with multiple worksheets. From one worksheet I am using other worksheet as my pivot datasource (pivot table range has been defined as a name, say myData). But when I am saving file back to MOSS document library, this datasource is changing back to the actual file name like http://mossserver/mydocLib/MyExcel.xls?myData, any idea why?

    • Moved by Mike Walsh FIN Wednesday, July 13, 2011 11:55 AM presumably not excel services as not posted there so is admin. (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
    Wednesday, July 13, 2011 10:50 AM

All replies

  • Hi Latiful,

    Thanks for sharing the post.

    From your description, I’m not sure whether I get your point.

    I have a test in my local (MOSS2007&Microsoft Excel 2010):

    1.       Create an excel file with two worksheet, having data in one sheet, design name for it (named mydata), create a pivot table in the second worksheet, type the design name (mydata) in Table/Range field.

    2.       Save the excel file in SharePoint list.

    3.        Reopen the file, and check the design name (mydata), it shows as normal, just a name.

    Do you mean that what you see is http://mossserver/mydocLib/MyExcel.xls?myData instead of the name you defined when you reopen the excel file?

    Thanks,

    Qiao Wei

    Friday, July 15, 2011 10:47 AM
    Moderator
  • Yes, I think you got my issue. But it is not happening always.

    Sometimes I do receive complain from the user about this. By the way, they are may be using office2003 or office2007, not to sure which one and when this is happening, but randomly appear.


    Friday, July 15, 2011 1:02 PM