access and excel

  1. F

    Excel Pivot through Access VBA

    I'm using excel/access 2007. I've an Access file based on which I'd like to create a brand new Excel file with a pivot table. So far I was able to create the file and the pivot table, but I'm unable to modify correctly the value of the pivot. It defaults to "Count of" while I'd like to have "Sum...
  2. S

    Updating existing PivotTables from external data (Ms Access)

    Dearest Excel Magicians, Wizards and Gods I have a report that was made some time ago (P&L report). It grew to 60mb at this point, and with all the pivots, caluclations etc - well, it got very obese, slow and lazy. I figured out, that I will move all the source data to MS Access database. But...
    • sidu86
    • Thread
    • access 2010 access and excel external data connection external data source pivot 2010
    • Replies: 0
    • Forum: Excel Questions
  3. N

    Adding Unnecessary Blank row on import from Access 2010 (Windows 7)

    Private Sub cmdCreateChart_Click()Dim dbs As DAO.Database Dim qdf As DAO.QueryDef Dim rst As DAO.Recordset Dim objXL As Object Dim lngLastDataRow As Long Set objXL = CreateObject("Excel.Application") Set dbs = CurrentDb 'Get the parameter query Set qdf = dbs.QueryDefs("qryCharts") 'Open a...
  4. J

    Run Access Query Using Pulled In excel files without duplicating data

    Hello, I have been running a report weekly using the below code in a module to pull all of the excel invoices I need into a query. My issue is that every week I have to rerun the report from scratch because if I just click run it will re-pull the same files I already have in it again. Is there...
  5. E

    Pull data in Access database to Excel

    Hi, I have an access database. I am trying to pull the data from that database to excel workbook and display it. This excel workbook is sits on a shared network drive and will be used by multiple users who will view the data pulled from access. Is it possible for multiple users to...
  6. M

    Loading .mdb file into Excel 2013

    I have a program that creates an .mdb file. I can import that file into Excel 2007 via the >Data>From Access menu chain. When I try to do the same thing in Excel 2013 I am presented with a Data Link Properties box with the connection tab selected. In Box 1 - The Data Source information appears...
  7. X

    Shared drive issue - saving file in access through excel

    Hello All, I have around ~100 users who are divided into 5 batches, they work on spreadsheet that has been shared on a network. My BIGGEST challenge is that since it is a shared spreadsheet it often leads to crashing or some or the other error popping up when opening the file. I somewhere read...
    • xtr3m3dud3
    • Thread
    • access and excel saving file saving workbook saving worksheet
    • Replies: 1
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top