Free Microsoft Excel 2013 Quick Reference

convert pdf table to excel 2007

I have a pdf file that I want to convert a table in the middle of the the document to excel 2007. The pdf table that I want to work with is in a users manual from my company's main customer. This user manual has page headers and page footers in it. The customer said the only way I will get the data for the work I need to complete is to convert the 297 pages from their pdf document to excel for me to work with. .
I work some a small company that does not have a budget for buying adobe acrobat. It looks like adobe acrobat would pull out all the tables I want to access easily. I have tried a few free online websites that convert a pdf file to excel, but they do not work. Do you know of any free website where I it would complete my goal of converting a pdf file to excel?
The only solution that I found that works but is a bad option is the following:
I select the part of the table I want for each page. (I need to repeat this process 297 times). I hit control c, I then have a word 2007 document and do a control v into the word document. From the word document I select what I just pasted into it, I then do a contol c from the word document into the excel 2007 excel sheet. I then do a control v into the excel document and that page of the data is formatted correctly.

Post your answer or comment

comments powered by Disqus

I use acrobat reader and excel 2003/2007. Is it possible to extract a table from a pdf file to excel without any additional software?

Best regards

I need to convert PDF files to formatted a Excel file so that I can make
adjustments to the amounts in one column.


I am weary from looking.

This link (and many others like it) open in the browser:

I would like to use VBA code to copy the page as a table, then paste it into an Excel 2007 spreadsheet.

Is there macro code that will "reach into" the PDF file in the browser window, select all, and copy as table?

Thanks so much...


How to Optimize the use of Query Table in Excel 2007 VBA?


I have an exisiting excel vba that uses QueryTable. The Macro runs fast before in excel 2003, but when we migrated to Excel2007 the macro's performance became very slow. Especilly when calling QueryTable.Add that uses an external url to get its connection. This line is being use repeatedly as it pulls information in the url with different inputs.

Is there anything I can use of other than QueryTable to pull records from a website?


I'm new here. I've never needed help with excel before, but we just upgraded to Excel 2007 (winXP) and a lot of my formulas from my old workbooks are not working. Specifically, the vlookup formula for data that comes from a pivot table.

I'm wondering if this is a known bug, or if there is some change to the way this is done in excel 2007, but I've read all the help and searched on google and couldn't find anything to help me.

Here's the situation:

On worksheet 1 I have bank downloaded data, worksheet 2 I have credit card transaction data, worksheet 3 is pivot table from CC transaction data (to sort by batch number), along with a vlookup to tie that total batch amount to the bank dowload information on worksheet 1.

The vlookup is only working on about 70% of the lines for some reason, the rest are displayed as #N/A even though the data is all there. It's all formatted correctly, no text or anything, they are all number formatted exactly the same. I don't understand how it could work for some of it but not all of it?

I'm not sure how to post examples, but the data in Worksheet 1 is simple and I'm only using columns A & B in my table lookup for the vlookup, A being the common cell and B being a date. So, my vlookup formula is as follows on worksheet 3:

=VLOOKUP(G5,'Bank Activities'!$A$2:$B$99,2,FALSE)

70% of the time, it is returning the correct date/value. For the other 30%, it is returning #N/A even though that value G5 or whatever is definitely in the table that is referenced. And it seems random, I can't find any similarities between the ones that are coming back fine and the ones that aren't working. And I just pulled down the formula for the whole sheet so there's nothing different between any of the formulas or data.

I'm sorry that was lengthy and probably confusing, it's so hard to explain this in words. Is there a way to attach the file I'm working on?

I have a pivot table in excel 2007 that is based on an external data source.
Assume the pivot table is arranged as the following: Sales by country,
region (of the country), by state, then county within the state.
I want a pivot table to extract the data and display a summarized value by
country with the ability to expand the segments as needed.
For example display sales by Canada, Mexico, USA. Then from that a user
will expand a country to display sales by region. Then expand a region to
display sales by state, then allow expansion to display by county.
As the report is run, the data should be presented in summary based on
country (for example Canada, Mexico, US)
Currently, after the data is refreshed, all columns are expanded showing a
very detailed report rather than a very summary report allowing the ability
to expand as needed. Currently, I need to collapse the columns before
presenting the data.
So… How do I get a Pivot table to default certain columns as collapsed,
rather than expanded?

Hello, when I use MS Query to retrieve data from MS SQL Server 2005, the data is returned in a table format. The table format doesn't allow for subtotalling. (A simple example would be to retrieve sales figures for a time period, and then create a subtotal for each sales rep and then create subtotals for each customer within each rep.)
When I convert the table to a range, Excel tells me that it will permanently remove the query. Removing the query makes it a one-time use only file. I'd like to retain the query so that it could be refreshed periodically to update the report.
Is there a way to retrieve data from a database and do subtotals without losing the query?



I want to convert .pdf files to excel format. I want to do this with VBA code as I am not allowed to install a software in my office.

Can anyone please suggest the solution?


I have an existing Word doc in table format. Some columns contain bulleted
items. How can I convert to Excel maintaining the bulleted format?

I am after a way to convert PDF or Word to excel, in a manner to separate the text based on headings. I mean creating a cell from one heading to another one.

I have several PDF files received from customers and need to convert them to Excel. Is there a way to do this?

Thanks. Pat

I am receiving the results of a Web-based test via e-mail. I am able to paste the e-mail's contents into an Excel spreadsheet and use it to manipulate the data as necessary, with one exception, namely an answer that requires the test taker to write a multi-paragraph e-mail response. I am able to identify which cells in Column A this answer occupies, for sake of argument, A60 to A70.

I want to have the contents of these cells appear in a single cell, B60, with linefeeds. I did find an Excel macro on this forum:

Sub FlexConcating()
Dim cell As Range
Dim r As Integer
Dim c As Integer
Dim Cnt As Integer
Cnt = -1
Dim strRslt As String
   For Each cell In Selection
       r = cell.Row
       c = cell.Column
       Cnt = Cnt + 1
       strRslt = strRslt & vbCrLf & cell
   Next cell
   Cells(r - Cnt, c + 1) = strRslt
End Sub
This works after a fashion, but there are undesirable leading spaces at the beginning of each paragraph.

If I instead copy the cells into a Word document, I notice that they come through as a table. If I convert the table to text in Word, then paste it back into the formula bar of B60, I get what I want.

My question is, can this be done wholly within Excel, without the need for Word?

Thanks in advance for any help on this.

Burt Spielman
Madison, NJ


I have never used pivot tables in 2003, so nothing of that sort... but whenever I use pivot tables in excel 2007, it irritates me, and people around me who generally claim that they could perhaps do it in excel 2003.

So here goes my questions.

1. How to make it remember what I have done right now? (Or may be how to change default settings?)
eg- In first column I have some classification, and then I have 12 months data, in 12 columns.
So I put first column in Row Label. Then I put 2nd column (first month data) in "Values" as "sum". Then I want to add all the months into the "values" column as sum, just by ticking in the checkboxes present in Field Section. But somehow excel behaves badly, it sometimes add the field into row label, or sometimes it will put the field in "values" but not as "sum" but as "count".

2. Is 24 month data too big to handle?
If I have 24 month data, and I want to add all the 24 fields in "values", it seems pretty irritating to me to drag each field into the right area and then set up the position of field section and area sections so that you can put next field in right place. (Or if you are dragging to pivot table itself instead of area sections, you will have to set up the position of worksheet so that you can put the next field in right place.

Please help with these two problems, it seems that I might ask more questions in future.

OK, here's the background. I have a client that is running Excel 200 on their local PC. They log into our network via RDP to a terminal server which is running Excel 2007. Last Tuesday we updated their server from Excel 2003 to Excel 2007.

I have a user that redirects her local drives up into the terminal server. She accesses many Excel files (2000 version) from her local PC to the terminal server. Ever since the update last week, she can not open a file from her local drive inside the terminal server, make changes, and re-save back to local. She gets a "Can Not Save" error message.

Is this an issue with converting from 2000 to 2007? She had no problems saving back and forth when they had 2003 previously.

I did blow away and recreate her profile on the server, thinking her profile could have been currupt, didn't help.

I should probably note that this doesn't just happen in Excel, she has the same issues with Word.

Any ideas???


I have created a table in excel 2007, however I can not figure out how to delete it. I don't want to delete the data in the table, just the table itself.

Any help is appreciated.


My company used to have Excel 2003. I had a PivotTable in a worksheet that accessed data in another, completely different worksheet. When we converted to Excel 2007, I saved many of my Excel files from .xls to .xlsm. My PivotTable that once accessed data from another .xls file is still trying to access that same .xls file. What I want, though, is for it to access the new .xlsm file. I'm struggling to find a way to do this. Any help?

My company has recently converted from Excel 2003 to Excel 2007, which is fine. I have continued to work as normal; however, I notice that saving files has become an issue, in fact, turned into a big problem. I get in a hurry and save it without regard to what version of Excel I'm saving the worksheet as. Now I've noticed multiple copies of some of the same speadsheets out there and I don't really know which copy is my latest and greatest. Also, spreadsheets that used to link to one another no longer do. I feel like this is my own doing for not being more judicious when it came to saving. Can anyone out there lend a hand? Thanks in advance.

Hi everyone.
I created a pivot table in Excel 2007. It had 5 columns and over 1800
rows (almost 10000 cells all together) and use to work fine in both
Excel 2007 & 2000.

There was one feature that I didn’t like however. It use to sort data in
one of the columns (column no. 2). Unfortunately these data should be
presented exactly as they were entered (without any sorting). To
workaround I added 1 extra column. It contains numbers in ascending
order. This column was placed in front of the column no. 2 and hidden.
Although I got rid of sorting, a new problem occurred – pivot works OK
in Excel 2007 only. Excel 2000 doesn’t accept such pivot table and I get
a message that it’s incorrect. If I want to reconfigure the pivot I get
a message that there is to many columns or rows and some of them should
be removed from the pivot.
Any ideas how to solve the problem of sorting without adding a new
column? Or maybe there is a way to force Excel 2000 to work with pivot
in conjunction with larger amount of data? Thanks in advance for any help.


I need to convert a spreadsheet from Excel 2007 Compatibility Mode, to Excel
2007. I did a file save as, but I only got the 65,536 lines like I had in
2003. I need the full amount like in FY2007. Anyone know how to do this?

I have some users who used the xlusrgal.xls file stored in
C:Documents and SettingsApplication DataMicrosoftexcel
to store their own chart templates in Excel 2003.

This doesn't seem to work in Excel 2007, and I see they have replaced it by
Chart templates (.crtx). These chart templates need to be stored in a
'Charts' folder underneath the regular template path.

The issue I have is that we lock down the template path for the firm (both
user and shared), but we want to allow users to create their own chart
templates by storing them to their profile as they could in 2003.

Any suggestions?

I am accustomed to working with Excel 2000. I now own Excel 2007. I know
that "lists" in Excel 2000 equate to "tables" in 2007. However, when I look
for the functions or buttons dealing with what was known as the "data form"
in Excel 2000, I cannot locate them. Are there data forms for data entry in
tables in Excel 2007? Are there analogs to data forms in 2007? Any help
anyone could be would be greatly appreciated.
Reed P. Wyatt

Trying to concert wb3 files from quattro pro into excel 2007. is there any
way to do this?

I have written an application that worked fine with Excel 2003.
I have upgraded to Excel 2007 and some problems occur when translating
Access tables into Excel charts.

Here is the sample of code of that worked fine with Excel 2003 :

Dim Excel As Excel.Application

Set Excel = New Excel.Application


Dim worksheet As Excel.worksheet

Dim r As Recordset
I = 1

Screen.MousePointer = 11


With Excel.ActiveSheet

..Range("A" & I).Value = "profileNumber"
..Range("B" & I).Value = "templateNumber"
..Range("C" & I).Value = "typeNumber"
..Range("D" & I).Value = "dates"

I = I + 1

On Error Resume Next

Set r = G_DBManager.GetModelElementsCount

Dim count As Long


Do Until r.EOF
..Range("A" & I).Value = r("profileNumber")
..Range("B" & I).Value = r("templateNumber")
..Range("C" & I).Value = r("typeNumber")
..Range("D" & I).Value = r("dates")

I = I + 1
' End If
count = r.RecordCount + 1
..Range("D").NumberFormat = "m/d/yy"
Excel.Visible = True

End With


With Excel.ActiveChart

..ChartType = xlLineMarkers
..HasAxis(xlCategory, xlPrimary) = True
..HasAxis(xlValue, xlPrimary) = True
..Axes(xlCategory).AxisBetweenCategories = True
..Axes(xlCategory, xlPrimary).CategoryType = xlCategoryScale
..Axes(xlCategory, xlPrimary).HasTitle = True
..Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "date"
..Axes(xlValue, xlPrimary).HasTitle = True
..Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = _
"Count of Model Elements"
..HasTitle = True
..ChartTitle.Characters.Text = "Count of Model Elements"

..SetSourceData Source:=Excel.ActiveSheet.Range("A1:C" & count), PlotBy:= _
..SeriesCollection(1).Values = "=Sheet1!R2C1:R" & count & "C1"
..SeriesCollection(1).name = "=Sheet1!R1C1"
..SeriesCollection(2).Values = "=Sheet1!R2C2:R" & count & "C2"
..SeriesCollection(2).name = "=Sheet1!R1C2"
..SeriesCollection(3).Values = "=Sheet1!R2C3:R" & count & "C3"
..SeriesCollection(3).name = "=Sheet1!R1C3"
..SeriesCollection(1).XValues = "=Sheet1!R2C4:R" & count & "C4"
..Location Whe=xlLocationAsObject, name:="Sheet1"

The chart is a Line type. The first 3 columns are the 3 parameters.( Y axis
value) .The 4th column is the date column ( X axis).

The problem is that the chart put the 4th column(dates) as a Y axis value in
Excel 2007.This is curious , especially since no problem was found for Excel
What is the problem with excel 2007 ?

Hi Experts

i want to prepare multiplication table using Excel 2007, how can i do it?

No luck finding an answer? You could always try Google.