# Latest

**URL:** https://forum.xltoolbox.net/latest.md?page=1

[Latest](https://forum.xltoolbox.net/latest.md) · [Categories](https://forum.xltoolbox.net/categories.md) · [Tags](https://forum.xltoolbox.net/tags.md)

**Page:** 2

---

## [Color of chart changes while exporting](https://forum.xltoolbox.net/t/color-of-chart-changes-while-exporting/821)

<div class="topic-metadata">

**Author:** [@anas](https://forum.xltoolbox.net/u/anas)\
**Replies:** 1\
**Last updated:** [February 26, 2020, 7:57pm UTC](https://forum.xltoolbox.net/t/color-of-chart-changes-while-exporting/821 "2020-02-26T19:57:19Z")

</div>

when I try to export charts in 300dpi the color of the chart gets changed(red line becomes blue). (png,300dpi, rgb,white canvas, color management)

---

## [TIFF file corruption if inserted into MS Word 2016 or emailed](https://forum.xltoolbox.net/t/tiff-file-corruption-if-inserted-into-ms-word-2016-or-emailed/813)

<div class="topic-metadata">

**Author:** [@Cal3](https://forum.xltoolbox.net/u/Cal3)\
**Replies:** 1\
**Last updated:** [February 1, 2020, 5:28am UTC](https://forum.xltoolbox.net/t/tiff-file-corruption-if-inserted-into-ms-word-2016-or-emailed/813 "2020-02-01T05:28:39Z")

</div>

Hi - This toolbox is creating efficiency and I love it. Found that I save a graph as a TIFF file, dpi 500 and then export. Insert into MS word doc. It is all fine. As soon as I try to change text wrapping or email this a…

---

## [PNG Files Saving with Black Borders Around Light Text](https://forum.xltoolbox.net/t/png-files-saving-with-black-borders-around-light-text/809)

<div class="topic-metadata">

**Author:** [@ACPhillips](https://forum.xltoolbox.net/u/ACPhillips)\
**Replies:** 1\
**Last updated:** [November 1, 2019, 7:17pm UTC](https://forum.xltoolbox.net/t/png-files-saving-with-black-borders-around-light-text/809 "2019-11-01T19:17:14Z")

</div>

I need to export a transparent background PNG file of a table of contents. The Chapter text is red bold Vectipede Regular font. (I have also tried a standard font like Arial). I can get the export but, there is a black…

---

## [Toolbox tries to modify Visio Installation](https://forum.xltoolbox.net/t/toolbox-tries-to-modify-visio-installation/808)

<div class="topic-metadata">

**Author:** [@rubisco](https://forum.xltoolbox.net/u/rubisco)\
**Replies:** 1\
**Last updated:** [November 1, 2019, 7:12pm UTC](https://forum.xltoolbox.net/t/toolbox-tries-to-modify-visio-installation/808 "2019-11-01T19:12:51Z")

</div>

A hello to the forum community and enthusiasts of Daniel’s XL Toolbox. I am using the plugin for an excel intensive project… all of a sudden, it stopped working, i.e. upon click on Chart Design, an installer opens but c…

---

## [Creating charts with labeled data clouds](https://forum.xltoolbox.net/t/creating-charts-with-labeled-data-clouds/116)

<div class="topic-metadata">

**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\
**Replies:** 2\
**Last updated:** [September 13, 2019, 5:24am UTC](https://forum.xltoolbox.net/t/creating-charts-with-labeled-data-clouds/116 "2019-09-13T05:24:43Z")

</div>

Scatter plots are a great way to visualize groups of data. Compared with bar graphs (with or without error bars), they have the added advantage of showing how the data are spread out. However, the basic scatter plot that…

---

## ["MS Excel is waiting for another application to complete an OLE action" error](https://forum.xltoolbox.net/t/ms-excel-is-waiting-for-another-application-to-complete-an-ole-action-error/806)

<div class="topic-metadata">

**Author:** [@Laura\_Tucker](https://forum.xltoolbox.net/u/Laura_Tucker)\
**Replies:** 1\
**Last updated:** [September 10, 2019, 4:28pm UTC](https://forum.xltoolbox.net/t/ms-excel-is-waiting-for-another-application-to-complete-an-ole-action-error/806 "2019-09-10T16:28:22Z")

</div>

Hi, I’m running the latest version (7.3.4) and trying to export some relatively small (\< 10MB) tiff images. Frequently, but not always, where I click the export button on the single graphic export window, I name my file …

---

## [Worksheet management](https://forum.xltoolbox.net/t/worksheet-management/136)

<div class="topic-metadata">

**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\
**Replies:** 4\
**Last updated:** [January 14, 2019, 3:20pm UTC](https://forum.xltoolbox.net/t/worksheet-management/136 "2019-01-14T15:20:46Z")

</div>

This is intended as an alternative to the worksheet tabs at the bottom of the screen, which is often difficult to work with when you have a lot of sheets in your Excel® file. This is a companion discussion topic for th…

---

## [Where to find preferences](https://forum.xltoolbox.net/t/where-to-find-preferences/791)

<div class="topic-metadata">

**Author:** [@Grafzahl](https://forum.xltoolbox.net/u/Grafzahl)\
**Replies:** 1\
**Last updated:** [June 9, 2019, 3:25pm UTC](https://forum.xltoolbox.net/t/where-to-find-preferences/791 "2019-06-09T15:25:15Z")

</div>

Hey guys After searching for like an hour i’m just unable to find the “preferences” on version 7.3.2. Can anyone help me?

---

## [1-Way Analysis Of Variance (ANOVA)](https://forum.xltoolbox.net/t/1-way-analysis-of-variance-anova/202)

<div class="topic-metadata">

**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\
**Replies:** 2\
**Last updated:** [May 12, 2019, 3:14pm UTC](https://forum.xltoolbox.net/t/1-way-analysis-of-variance-anova/202 "2019-05-12T15:14:45Z")

</div>

The ANOVA makes a general statement about whether or not there are significant differences between the data groups. Once the result is positive (p \< 0.05), you need to employ additional tests to find out which of the mul…

---

## [Dateinamen beim Abspeichern von Charts](https://forum.xltoolbox.net/t/dateinamen-beim-abspeichern-von-charts/782)

<div class="topic-metadata">

**Author:** [@fralu](https://forum.xltoolbox.net/u/fralu)\
**Replies:** 1\
**Last updated:** [May 12, 2019, 2:13pm UTC](https://forum.xltoolbox.net/t/dateinamen-beim-abspeichern-von-charts/782 "2019-05-12T14:13:15Z")

</div>

Beim Abspeichern von Grafiken wird aktuell das Schema {Arbeitsmappe}{Tabellenblatt}{Index} für den Dateinamen verwendet. Gibt es eine Möglichkeit, den Namen des Charts einzubinden? Besten Dank und schöne Grüße Frank

---

## [Create lecters of groups](https://forum.xltoolbox.net/t/create-lecters-of-groups/777)

<div class="topic-metadata">

**Author:** [@Eughenos](https://forum.xltoolbox.net/u/Eughenos)\
**Replies:** 3\
**Last updated:** [April 8, 2019, 9:16am UTC](https://forum.xltoolbox.net/t/create-lecters-of-groups/777 "2019-04-08T09:16:55Z")

</div>

Good evening, I am starting now to use this fantastic tool and so I am not ready to manage all the options. My question is: Is possible to have another list with the lecter of the groups? In the dumbly example is pr…

---

## [Export Picture with a precise size](https://forum.xltoolbox.net/t/export-picture-with-a-precise-size/775)

<div class="topic-metadata">

**Author:** [@Eduardo\_Godoy](https://forum.xltoolbox.net/u/Eduardo_Godoy)\
**Replies:** 4\
**Last updated:** [April 3, 2019, 7:10pm UTC](https://forum.xltoolbox.net/t/export-picture-with-a-precise-size/775 "2019-04-03T19:10:23Z")

</div>

Hi, I need to export a picture from my spreadsheet with the exact size of 590 x 380 pixels. I copied and pasted as a picture with linking the cells that I want. When I copied and pasted in the Paint app, it works very …

---

## [Export file size](https://forum.xltoolbox.net/t/export-file-size/772)

<div class="topic-metadata">

**Author:** [@Hurrellg](https://forum.xltoolbox.net/u/Hurrellg)\
**Replies:** 1\
**Last updated:** [March 12, 2019, 8:48am UTC](https://forum.xltoolbox.net/t/export-file-size/772 "2019-03-12T08:48:51Z")

</div>

I have exported some graphs as 800dpi transparent TIFF files. Whilst they look OK i am puzzled why they only are 500kB approx each whereas the Export dialog box indicated that the file size would be about 15MB. Am I miss…

---

## [Daniel's XL Toolbox -
Spread Scatter](https://forum.xltoolbox.net/t/daniels-xl-toolbox-spread-scatter/92)

<div class="topic-metadata">

**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\
**Replies:** 2\
**Last updated:** [February 24, 2019, 6:50pm UTC](https://forum.xltoolbox.net/t/daniels-xl-toolbox-spread-scatter/92 "2019-02-24T18:50:32Z")

</div>

Spreading a scatter plot is accomplished by changing the values in the cells for the X axis so that the data points are spread out along the X axis. You normally do not see the effect, because the number formatting in th…

---

## [Bulk Export works for 4 charts, then fails](https://forum.xltoolbox.net/t/bulk-export-works-for-4-charts-then-fails/764)

<div class="topic-metadata">

**Author:** [@CPM253](https://forum.xltoolbox.net/u/CPM253)\
**Replies:** 5\
**Last updated:** [February 8, 2019, 4:55am UTC](https://forum.xltoolbox.net/t/bulk-export-works-for-4-charts-then-fails/764 "2019-02-08T04:55:01Z")

</div>

XL Toolbox 7.3.4 Excel 64-Bit Windows 10 I’ve exported ~160 charts as 1200 dpi tiff’s successfully, but for some reason I cannot export any additional charts. I run the bulk exporter and a window pops up momentarily,…

---

## [XLToolbox 7.3.4 fails to install on Excel 365 with a Certificate Not Trusted error](https://forum.xltoolbox.net/t/xltoolbox-7-3-4-fails-to-install-on-excel-365-with-a-certificate-not-trusted-error/755)

<div class="topic-metadata">

**Author:** [@sdlitvin](https://forum.xltoolbox.net/u/sdlitvin)\
**Replies:** 3\
**Last updated:** [January 7, 2019, 12:42am UTC](https://forum.xltoolbox.net/t/xltoolbox-7-3-4-fails-to-install-on-excel-365-with-a-certificate-not-trusted-error/755 "2019-01-07T00:42:06Z")

</div>

I’m able to double-click on the XLToolbox EXE file to install it. But in Excel, when I try to add the XL Toolbox COM add-in, I get the following error message dialog box: “Customized functionality in this application w…

---

## [What I like and dislike about Ubuntu 17.10](https://forum.xltoolbox.net/t/what-i-like-and-dislike-about-ubuntu-17-10/752)

<div class="topic-metadata">

**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\
**Replies:** 0\
**Last updated:** [December 20, 2018, 4:41am UTC](https://forum.xltoolbox.net/t/what-i-like-and-dislike-about-ubuntu-17-10/752 "2018-12-20T04:41:31Z")

</div>

Ubuntu 18.04 is out, and similarly to 17.10, there are a couple of things that I like and dislike about it. This is a companion discussion topic for the original entry at https://www.xltoolbox.net/blog/2018/05/what-i-l…

---

## [High-resolution graphs for publication](https://forum.xltoolbox.net/t/high-resolution-graphs-for-publication/99)

<div class="topic-metadata">

**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\
**Replies:** 12\
**Last updated:** [November 30, 2018, 8:07pm UTC](https://forum.xltoolbox.net/t/high-resolution-graphs-for-publication/99 "2018-11-30T20:07:59Z")

</div>

An alternative to the high-resolution graphic export is the screenshot-quality export: This is better suited for graphs that you want to use in digital media, e.g. in e-mails or presentations. One important differenc…

---

## [New user having issue with Excel 365 on windows 10](https://forum.xltoolbox.net/t/new-user-having-issue-with-excel-365-on-windows-10/740)

<div class="topic-metadata">

**Author:** [@somann](https://forum.xltoolbox.net/u/somann)\
**Replies:** 3\
**Last updated:** [November 8, 2018, 8:01pm UTC](https://forum.xltoolbox.net/t/new-user-having-issue-with-excel-365-on-windows-10/740 "2018-11-08T20:01:00Z")

</div>

I hope I’m not just reposting anything but I have not seen the same issue as I’m having. I downloaded the toolbox and was able to use it yesterday to test the .tif conversion… worked great. This morning it started givin…

---

## [Windows 10, 64 bit and Excel 365](https://forum.xltoolbox.net/t/windows-10-64-bit-and-excel-365/724)

<div class="topic-metadata">

**Author:** [@David\_Bromwich](https://forum.xltoolbox.net/u/David_Bromwich)\
**Replies:** 4\
**Last updated:** [September 16, 2018, 11:50am UTC](https://forum.xltoolbox.net/t/windows-10-64-bit-and-excel-365/724 "2018-09-16T11:50:11Z")

</div>

With v 7.3.1 exe, I get 'This app can’t run on your PC. To find a version for your PC, check with the software publisher." With Excel 365 it runs OK for a while, then all the top menus disappear. It may be XLToolBox

---

## [Clear Pivot Table Cache](https://forum.xltoolbox.net/t/clear-pivot-table-cache/688)

<div class="topic-metadata">

**Author:** [@Alan\_Jones](https://forum.xltoolbox.net/u/Alan_Jones)\
**Replies:** 3\
**Last updated:** [September 6, 2018, 3:14pm UTC](https://forum.xltoolbox.net/t/clear-pivot-table-cache/688 "2018-09-06T15:14:12Z")

</div>

Have you considered adding a feature to clear the Pivot Table Cache? I have run into issues when my raw data is updated the filters/slicers still show old (and new ) data. I did not understand this till I realized it was…

---

## [Office 365 / Excel 2016 Compatibility Installation Error](https://forum.xltoolbox.net/t/office-365-excel-2016-compatibility-installation-error/687)

<div class="topic-metadata">

**Author:** [@mariahmh](https://forum.xltoolbox.net/u/mariahmh)\
**Replies:** 11\
**Last updated:** [September 6, 2018, 3:10pm UTC](https://forum.xltoolbox.net/t/office-365-excel-2016-compatibility-installation-error/687 "2018-09-06T15:10:59Z")

</div>

I’m getting an installation error when I try to install the toolbox. I double click it, it has me select a language, then I am immediately given the error “This add-in requires Office 2007 or later. Setup will now termin…

---

## [Unable to export .tiff file](https://forum.xltoolbox.net/t/unable-to-export-tiff-file/709)

<div class="topic-metadata">

**Author:** [@bappa\_10085](https://forum.xltoolbox.net/u/bappa_10085)\
**Replies:** 2\
**Last updated:** [September 2, 2018, 7:58am UTC](https://forum.xltoolbox.net/t/unable-to-export-tiff-file/709 "2018-09-02T07:58:15Z")

</div>

I am trying to export image file from excel using XL Toolbox. But it is showing the following error An error occurred during export. The following error message was received: Unable to cast COM object of type ‘System.…

---

## [Exit ThinkPad T430s, enter ThinkPad T480s](https://forum.xltoolbox.net/t/exit-thinkpad-t430s-enter-thinkpad-t480s/710)

<div class="topic-metadata">

**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\
**Replies:** 0\
**Last updated:** [August 24, 2018, 12:35pm UTC](https://forum.xltoolbox.net/t/exit-thinkpad-t430s-enter-thinkpad-t480s/710 "2018-08-24T12:35:46Z")

</div>

I recently purchased a new laptop. My old Thinkpad T430s had come of age. Its keyboard fell apart, its body had a crack (after a fall), and the hard drive was full. These are all things that can be taken care of, especia…

---

## [Linux and VirtualBox on a T480s with high-resolution display](https://forum.xltoolbox.net/t/linux-and-virtualbox-on-a-t480s-with-high-resolution-display/674)

<div class="topic-metadata">

**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\
**Replies:** 0\
**Last updated:** [July 26, 2018, 4:39pm UTC](https://forum.xltoolbox.net/t/linux-and-virtualbox-on-a-t480s-with-high-resolution-display/674 "2018-07-26T16:39:02Z")

</div>

My new Thinkpad T480s has a 14” high-resolution WQHD display with a resolution of 2560 &mult; 1440 pixels. It looks great. PDF files display super crisp. Programming with lots of different panels and windows, and data an…

---

## [Exception from HRESULT: 0x80131040 \[Version=7.2.12.0\]](https://forum.xltoolbox.net/t/exception-from-hresult-0x80131040-version-7-2-12-0/481)

<div class="topic-metadata">

**Author:** [@ccss](https://forum.xltoolbox.net/u/ccss)\
**Replies:** 4\
**Last updated:** [May 10, 2018, 11:58am UTC](https://forum.xltoolbox.net/t/exception-from-hresult-0x80131040-version-7-2-12-0/481 "2018-05-10T11:58:54Z")

</div>

Installing the latest version I received this error. Note. After first failure I removed the add-in and tried to install again: Could not load file or assembly 'XLToolboxForExcel, Version=7.2.12.0, Culture=neutral, Pub…

---

## [What I like and dislike about Ubuntu 18.04](https://forum.xltoolbox.net/t/what-i-like-and-dislike-about-ubuntu-18-04/588)

<div class="topic-metadata">

**Author:** [@Daniel](https://forum.xltoolbox.net/u/Daniel)\
**Replies:** 0\
**Last updated:** [May 3, 2018, 7:54am UTC](https://forum.xltoolbox.net/t/what-i-like-and-dislike-about-ubuntu-18-04/588 "2018-05-03T07:54:59Z")

</div>

Ubuntu 18.04 is out, and similarly to 17.10, there are a couple of things that I like and dislike about it. This is a companion discussion topic for the original entry at https://www.xltoolbox.net/blog/2018/05/what-i-l…

---

## [VBA error when setting error bars](https://forum.xltoolbox.net/t/vba-error-when-setting-error-bars/493)

<div class="topic-metadata">

**Author:** [@ummok](https://forum.xltoolbox.net/u/ummok)\
**Replies:** 3\
**Last updated:** [February 2, 2018, 9:00pm UTC](https://forum.xltoolbox.net/t/vba-error-when-setting-error-bars/493 "2018-02-02T21:00:44Z")

</div>

Hi, I’m trying to use the error bar tool. I have a graph with 32 series (I copy the graph and delete series that I don’t want to display later, but it’s easier to put all 32 series in one graph at once at first). My stan…

---

## [Hello Everyone,](https://forum.xltoolbox.net/t/hello-everyone/55)

<div class="topic-metadata">

**Author:** [@017hnoor](https://forum.xltoolbox.net/u/017hnoor)\
**Replies:** 6\
**Last updated:** [January 21, 2018, 5:42pm UTC](https://forum.xltoolbox.net/t/hello-everyone/55 "2018-01-21T17:42:49Z")

</div>

Hello Everyone, I exported Excel charts as TIF to be used for a scientific publication. This specific journal allows the upload of charts as either TIF or alternatively as PDF. Following the upload of files a PDF documen…

---

## [Box plot and histogram export](https://forum.xltoolbox.net/t/box-plot-and-histogram-export/449)

<div class="topic-metadata">

**Author:** [@Jaroslav\_Burian](https://forum.xltoolbox.net/u/Jaroslav_Burian)\
**Replies:** 2\
**Last updated:** [December 20, 2017, 8:40am UTC](https://forum.xltoolbox.net/t/box-plot-and-histogram-export/449 "2017-12-20T08:40:45Z")

</div>

Hi, I am not able to export my charts (histogram and box plot) to any graphical format. Export of other “classical” chart types works perfectly, so there will be probably problem with these new types. Here is error mes…

[Previous page](https://forum.xltoolbox.net/latest.md)

[Next page](https://forum.xltoolbox.net/latest.md?page=2)
