Excel - Overwrite Specific Tabs

[suby]

Hi All,

I'm overwriting some of the tabs in my excel workbook and whenever i open the output file i get this message and specifically around  'Sheet 13'.

""We found a problem with some content, do you want us to try to recover as much as we can?""

The one thing  i could see in 'Sheet 13' there are some couple of text fields which has got some truncated characters is this causing a problem?

I tried lots of search and i couldn't find any solutions.

Thanks

[Emmanuel_G]

Hi @suby 

Have you tried to increase the size of the field so that the characters are not truncated and redo a test of opening sheet 13?

[suby]

Hi,

That is purely a display issue within Alteryx right? 

Is there anything else that could cause the issue and i'm facing this and redone all my work and still facing the same issue..

[Emmanuel_G]

@suby 

Is it possible to provide even a sample of the content that goes into sheet 13 for testing?

[suby]

Hi,

Sorry unfortunately i cant provide the data due to security reasons but i have mocked up the data some of the column hold values as below.

Column 1	column 2	Column 3	Column 4	Column 5
1. some text	[1] Some Text	[1] Some Text: · -Some Text. -some Text	Some Text. • Some Text. • Some Text	The "some text" must : - Some text. - Some text
1)    some text

Thanks any pointes would be much appreciated.

Thanks

[MattBSlalom]

I'm not familiar with the error message, but I wonder if it's an issue with some of those special characters in the text values (like the bullets).  Have you tried wrapping those values in an Excel formula syntax?  So instead of writing:

1. some text

it becomes:

="1. some text"

Alternatively, it may be worth trying to replace variations of the bullets to a known version that writes successfully like the hyphen "-".