Reducing the size of Microsoft Excel file automatically
Here is a quick tip on reducing the size of Microsoft Excel file quickly and easily. You may need to reduce it for any number of reasons, and this is a quick way to get that done.
- Launch Microsoft Excel or the Microsoft Workbook in question
- Go to Files -> Options
-> Add Ins
- In the “Manage”
drop-down box, select “COMS Add-ins” and click Go. Select the
- This creates an
“Inquire” tab in your Excel workbook.
- Under “Inquire”, select the feature “Clean Excess Cell Formatting”.
This process will clean all the "white noise" which builds up especially in those workbooks that have had a lot of changes to them.
Setting up an Excel ODBC (32bit) System DSN
Issue You would like to connect to Excel files to use as data in your Intelligence Reports Resolution You need to configure a 32bit System DSN on all workstations. Instructions as follows: Set up a System Data Source Name (DSN) using the Microsoft ...
Enabling Macro Settings in Microsoft Excel
Desired Settings To enable many of the Intelligence Reporting reports to run, you need to ensure that all Macro's are fully enabled as they are used extensively throughout all of the reports. Change macro settings in the Trust Center Macro settings ...
Number 75: Path/File access error
Problem When launching any module of Intelligence Reporting, you get a file/access path error When trying to run a report you get this error Resolution Check that you have full read/write access to the Metadata Repository Check that you have full ...
The Power of Slicers
Slicers provide buttons that you can click to filter table data, or PivotTable data. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is shown in a filtered ...
Create a PivotTable to analyze worksheet data
Being able to quickly analyze data can help you make better business decisions. But sometimes it’s hard to know where to start, especially when you have a lot of data. PivotTables are a great way to summarize, analyze, explore, and present your data, ...