Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ComboBox .AddItem Permission Denied
Hello all, I need to populate a ComboBox in a UserForm by using VBA rather than referencing an range in excel. Referencing a range in Excel will not work for this project. All the references I've found so far indicate that the following code should work; but I wind up with a Permission...- ekongirl
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Pivot Table: How to show all levels in field even if empty
In creating a pivot table, is there a way to "show all" even if there isn't any data? example: Name value category1 $40 category2 $60 category3 0 Usually, category3 would be filtered out by the pivot table because it is empty. I need the category to be displayed regardless...- ekongirl
- Thread
- Replies: 6
- Forum: Microsoft: Office
-
Cannot use OLAP Services 8.0 to connect to Cube
when mapping a cube, I can select the Microsoft OLE DB provider for OLAP Services 8.0, but am not able to connect. I can only connect using the older OLAP service provider... which results in an error when building a pivot table in Excel. I've seen this problem expressed by other users, but...- ekongirl
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
