I am using Excel 2007.
I use MSQuery to connect using ODBC to an Oracle server and get data into table.
I am trying to use subtotals, but it seems not working with data from table!!
Can anyone support how to overcome this issue or use a VB macro to dynamicly calculates subtotals as table is...
Is there any possibilities to share a workbook that contains sheets with data retrieved and updated from external ODBS sources?
Is there any workaround, special add-ins, 3rd-party tools or other Microsoft solutions?
I had VISTA 32 on my DELL latitude D520 and recently installed Vista SP1 and Nokia PC Suite 6.86.9.3.
Suddenly, my bluetooth connection with my Nokia mobile N70 is no more working. I think this is mainly due to the VISTA and not due to the PC Suite. This is because the Bluetooth icon start in...
I have recently joined my company domain. The domain administrator has set the group policy to make windows update managed by system administrator by default.
How to make the default windows update being through online update rather than the domain update?
I need to use my Outlook 2007 to send/receive emails using the http connectivity with Exchange 2007. This is done inside my company, and am able to use Iexplorer to login to my inbox from outside the company. Now, I need to do this using my Outlook 2007. My company admin does not provide my any...
I have a table with the following data:
Code Effective_date
A 1/1/2008
A 1/2/2008
A 15/5/2008
B 1/1/2008
B 15/2/2008
C 1/2/2008
C 1/4/2008
I need to get the following output:
Code Effective_1 Effective_2
A 1/1/2008 31/1/2008
A...
I am using VISTA business SP1 on Dell Latitude D520.
I just joined a new Domain in my company network.
After this recent join, I am not able to find my boot system drive C in explorer or my computer. However, when I write C:\ and press enter, It displays.
Has anyone any idea how to be able to...
I have a sheet with the following data:
A B C D E F G H M
1 Code Jan Feb Mar Apr May Jun Jul ------- Dec
2 A 10 11 1 5 9 3 10 8
3 B 4 2 33 9 1 0 12 4
4 C
5 D...
Can experts help?
I have a 2 columns; A containing product_id and B containing item_id. Each row contains the product_id and one of its item_id. Suppose rows are sorted so that all product_id, item_id are ordered by product_id.
I need to construct a row range for each product_id; that is for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.