Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
erratic response while working on a table in excel linked to a tab
Reporting of a bug and help needed
Description: 1. I find PivotTable very useful and use it quite often even in Access to get the desired reports. 2. Till Access 2000 there was a way to create a form with embedded Pivot Table. But it was discontinued in access 2003. It had (if I can recall correctly) pivot form. Which was similar yet different from the embedded PivotTable of Access 2000? 3. But fortunately the Forms with embedded PivotTable created in earlier version worked well in Access 2003. So there was not much problem. The only problem was that no new such forms could be created. 4. The problem remained in Access 2007 also. Here also no new form with embedded PivotTable can be created but work well if created in earlier version. But problem comes when new form with embedded PivotTable is needed. 5. As a roundabout way I created a separate excel sheet, imported the table through a link and made a PivotTable out of it. 6. Now here again there are two ways of linking. One by choosing €śFrom Access€ť option and other by choosing €śFrom Microsoft query€ť. Both works fine if the mdb file is not open while working on linked PivotTable. The problem comes when the mdb file is opened. In such a case, if €śFrom access€ť option is chosen then it simply does not work. It says €śthe database is opened exclusively by admin€¦. etc€ť. If the link is created by choosing €śFrom Microsoft query€ť then at times it works fine and at times it shows same message ie €ś the database is opened exclusively by admin€¦. etc€ť. 7. Now since it works sometimes in the second option I feel technically it is not necessary to have the linked mdb closed while working in the PivotTable. So it is definitely a bug. 8. This opinion is strengthened because of its erratic behavior when the second option is chosen. 9. On internet I find similar experience of few others also so it is not a machine specific problem. So the bug is the erratic response while working on a table in excel linked to a table in Access while the containing mdb file is open. In addition to this I would seek help from all people more intelligent to me to kindly show me some way to create a form with embedded PivotTable in Access2007. This is needed a it is slightly inconvenient to carry two files ie one mdb and other xls as if moved to other computer every time the links have to be recreated. ---------------- 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/office/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
erratic response while working on a table in excel linked to a tab
Hi,
I think you should post the Access form questions with the Access Newsgroup: http://www.microsoft.com/communities...&lang=en&cr=US -- If this helps, please click the Yes button. Cheers, Shane Devenshire "S K Srivastava" wrote: Reporting of a bug and help needed Description: 1. I find PivotTable very useful and use it quite often even in Access to get the desired reports. 2. Till Access 2000 there was a way to create a form with embedded Pivot Table. But it was discontinued in access 2003. It had (if I can recall correctly) pivot form. Which was similar yet different from the embedded PivotTable of Access 2000? 3. But fortunately the Forms with embedded PivotTable created in earlier version worked well in Access 2003. So there was not much problem. The only problem was that no new such forms could be created. 4. The problem remained in Access 2007 also. Here also no new form with embedded PivotTable can be created but work well if created in earlier version. But problem comes when new form with embedded PivotTable is needed. 5. As a roundabout way I created a separate excel sheet, imported the table through a link and made a PivotTable out of it. 6. Now here again there are two ways of linking. One by choosing €śFrom Access€ť option and other by choosing €śFrom Microsoft query€ť. Both works fine if the mdb file is not open while working on linked PivotTable. The problem comes when the mdb file is opened. In such a case, if €śFrom access€ť option is chosen then it simply does not work. It says €śthe database is opened exclusively by admin€¦. etc€ť. If the link is created by choosing €śFrom Microsoft query€ť then at times it works fine and at times it shows same message ie €ś the database is opened exclusively by admin€¦. etc€ť. 7. Now since it works sometimes in the second option I feel technically it is not necessary to have the linked mdb closed while working in the PivotTable. So it is definitely a bug. 8. This opinion is strengthened because of its erratic behavior when the second option is chosen. 9. On internet I find similar experience of few others also so it is not a machine specific problem. So the bug is the erratic response while working on a table in excel linked to a table in Access while the containing mdb file is open. In addition to this I would seek help from all people more intelligent to me to kindly show me some way to create a form with embedded PivotTable in Access2007. This is needed a it is slightly inconvenient to carry two files ie one mdb and other xls as if moved to other computer every time the links have to be recreated. ---------------- 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/office/comm...lic.excel.misc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
erratic response while working on a table in excel linked to a
The issue pertains both access and excel. It is also not clear whether the
problem is in excel or in access. Hence it has been posted in both. "Shane Devenshire" wrote: Hi, I think you should post the Access form questions with the Access Newsgroup: http://www.microsoft.com/communities...&lang=en&cr=US -- If this helps, please click the Yes button. Cheers, Shane Devenshire "S K Srivastava" wrote: Reporting of a bug and help needed Description: 1. I find PivotTable very useful and use it quite often even in Access to get the desired reports. 2. Till Access 2000 there was a way to create a form with embedded Pivot Table. But it was discontinued in access 2003. It had (if I can recall correctly) pivot form. Which was similar yet different from the embedded PivotTable of Access 2000? 3. But fortunately the Forms with embedded PivotTable created in earlier version worked well in Access 2003. So there was not much problem. The only problem was that no new such forms could be created. 4. The problem remained in Access 2007 also. Here also no new form with embedded PivotTable can be created but work well if created in earlier version. But problem comes when new form with embedded PivotTable is needed. 5. As a roundabout way I created a separate excel sheet, imported the table through a link and made a PivotTable out of it. 6. Now here again there are two ways of linking. One by choosing €śFrom Access€ť option and other by choosing €śFrom Microsoft query€ť. Both works fine if the mdb file is not open while working on linked PivotTable. The problem comes when the mdb file is opened. In such a case, if €śFrom access€ť option is chosen then it simply does not work. It says €śthe database is opened exclusively by admin€¦. etc€ť. If the link is created by choosing €śFrom Microsoft query€ť then at times it works fine and at times it shows same message ie €ś the database is opened exclusively by admin€¦. etc€ť. 7. Now since it works sometimes in the second option I feel technically it is not necessary to have the linked mdb closed while working in the PivotTable. So it is definitely a bug. 8. This opinion is strengthened because of its erratic behavior when the second option is chosen. 9. On internet I find similar experience of few others also so it is not a machine specific problem. So the bug is the erratic response while working on a table in excel linked to a table in Access while the containing mdb file is open. In addition to this I would seek help from all people more intelligent to me to kindly show me some way to create a form with embedded PivotTable in Access2007. This is needed a it is slightly inconvenient to carry two files ie one mdb and other xls as if moved to other computer every time the links have to be recreated. ---------------- 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/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Value from Table erratic | Excel Worksheet Functions | |||
Link in e-mail notification of a response is not working | Excel Discussion (Misc queries) | |||
Again for Formula that isn't working...Had response but not workin | Excel Worksheet Functions | |||
How do I transform a word response to a numeric response? | Excel Discussion (Misc queries) | |||
How do I set up a daily call out response response register? | Excel Worksheet Functions |