Search Contextures Sites
Excel Weekly News from Contextures Mar 19, 2012Convert a PDF file to Excel, stop those confusing macro warnings, and other tips for you, in this week's Excel news from Contextures.- Debra firstname.lastname@example.org
Fix Macro Warning in Workbook With No MacrosEven if you delete all macros from an Excel workbook, you may still see a security warning when the workbook opens. The message says "Macros may contain viruses. It is usually safe to disable macros, but if the macros are legitimate, you might lose some functionality." Then you have the option to click a button to "Enable Macros" or "Disable Macros".
This message is confusing, if you know that there are no Excel macros in this workbook. When you check the list of macros, nothing appears in the list.
This video shows you how to get rid of that warning, by deleting the modules where the old macros were stored. After you follow these steps, and save the Excel workbook, the macro warning will not appear, the next time that you open the Excel workbook.
Follow the steps in my video, to delete the empty modules in the workbook, and that should prevent the security warning from appearing.
If you prefer written instructions, there are detailed steps on the Contextures website.
Convert PDF File to Excel
By using the free online service, pdftoexcelconverter.net, I was able to convert a PDF file to Excel format, quickly and easily.
The website states that your privacy will be protected, but you'll have to enter a valid email address, to have the download link sent to you.
If you need to convert confidential documents, you can use a desktop PDF converter instead. I've used Able2Extract Pro in the past, and had good results with that.
Excel Recipe Nutrients CalculatorThere is a new recipe calculator in the latest version of my Excel Calorie Counter workbook. Input all of the recipe ingredients, and Excel calculates the calories, carbs, protien, fibre and fat per serving.
After you calculate the recipe's nutrients, you can add that as an item in the workbook's food list.
See the details in the Contextures Blog article: Excel Recipe Nutrients Calculator
Freezing Excel Rows and Columns While Scrolling
This week, the Excel team at Microsoft shows the steps for freezing rows at the top of the worksheet, or columns at the left. Then, when you scroll, those rows stay in place, so it's easier to read and understand the data.
You can see their short video here: Freezing Rows and Columns in Excel
Writing Arrays to the worksheet - VBA function
On his Newton Excel Bach blog, Doug Jenkins lists his VBA code for efficiently writing a VBA array to the spreadsheet as quickly as possible.
The code is in a function that can be called from any other VBA routine, and it includes optional features, such as parameters that allow part of the array to be written to the spreadsheet.
You can copy Doug's code from his blog, or download the sample file.
Excel HumourOnce again, I read the Excel tweets, so you don't have to! Here are a few favourites from this week. You can read the rest of the tweet collection here.
- Need. Coffee. Now. (also chocolate, and a change of CD) #excel #charts.
- If it is wrong to <3 Excel Pivot Charts I don't want to be right.
- I had to watch a video on Youtube to figure out how to make a chart on Excel. That's where I'm at in life.
Recommended Excel Tools
Contextures Inc., Copyright ©2017
All rights reserved.