| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot Open Pivot Table Source
On 7/13/07, some else posted an issue with an error message: "Cannot Open
Pivot Table Source". It was not answered during that time. Here is my issue & question: For one of my pivot tables that I have created, users have reported that they are receiving the following error message: "Cannot Open Pivot Table Source File". Am I doing something wrong as the creator of the pivot table or is there something I need to do to avoid this error message? -- Thanks, enkay |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cannot Open Pivot Table Source
If you provide some details on this workbook, someone may be able to
help. For example: Is the source file external, and if so, where is it located? Do all users have permissions in the folder? Are users opening the file in Excel? What version? Is the workbook shared? Is there something different about this pivot table, aside from the error message? enkay wrote: On 7/13/07, some else posted an issue with an error message: "Cannot Open Pivot Table Source". It was not answered during that time. Here is my issue & question: For one of my pivot tables that I have created, users have reported that they are receiving the following error message: "Cannot Open Pivot Table Source File". Am I doing something wrong as the creator of the pivot table or is there something I need to do to avoid this error message? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cannot Open Pivot Table Source
Thank you for your reply. Another person addressed the answer to my question.
-- Thanks, enkay "Debra Dalgleish" wrote: If you provide some details on this workbook, someone may be able to help. For example: Is the source file external, and if so, where is it located? Do all users have permissions in the folder? Are users opening the file in Excel? What version? Is the workbook shared? Is there something different about this pivot table, aside from the error message? enkay wrote: On 7/13/07, some else posted an issue with an error message: "Cannot Open Pivot Table Source". It was not answered during that time. Here is my issue & question: For one of my pivot tables that I have created, users have reported that they are receiving the following error message: "Cannot Open Pivot Table Source File". Am I doing something wrong as the creator of the pivot table or is there something I need to do to avoid this error message? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cannot Open Pivot Table Source
This may be happening because the pivot is trying to refresh on opening and
you don't have the source from which the pivot was created. Either the initial 'owner' need to save the data with the workbook, or he needs to 'break the link' and you will just get a 'flat' version of the data Here are some references that you should check http://support.microsoft.com/kb/831929/en-us http://support.microsoft.com/kb/117314 -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! "enkay" wrote: On 7/13/07, some else posted an issue with an error message: "Cannot Open Pivot Table Source". It was not answered during that time. Here is my issue & question: For one of my pivot tables that I have created, users have reported that they are receiving the following error message: "Cannot Open Pivot Table Source File". Am I doing something wrong as the creator of the pivot table or is there something I need to do to avoid this error message? -- Thanks, enkay |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cannot Open Pivot Table Source
Thank you so very much. The first link that you provided is the answer I'm
looking for to help solve my problem. This error does not occur all the time only a couple of times by the same user but it does not affect the other users. Now I can share with the one user, what is happening and a work around to this problem. -- Thanks, enkay "Pranav Vaidya" wrote: This may be happening because the pivot is trying to refresh on opening and you don't have the source from which the pivot was created. Either the initial 'owner' need to save the data with the workbook, or he needs to 'break the link' and you will just get a 'flat' version of the data Here are some references that you should check http://support.microsoft.com/kb/831929/en-us http://support.microsoft.com/kb/117314 -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! "enkay" wrote: On 7/13/07, some else posted an issue with an error message: "Cannot Open Pivot Table Source". It was not answered during that time. Here is my issue & question: For one of my pivot tables that I have created, users have reported that they are receiving the following error message: "Cannot Open Pivot Table Source File". Am I doing something wrong as the creator of the pivot table or is there something I need to do to avoid this error message? -- Thanks, enkay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
| entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
| cannot open pivot table source file - error | Excel Worksheet Functions | |||
| Transforming pivot table back to the source table | Excel Worksheet Functions | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Hybrid Mode
