Output Data (45) sheetname is an invalid Sheet/Range specification for Excel

saachitalwar

I have data in the form:

col1 col2 col3

A X data

A Y data

A Z data

B U data

B V data

B w data

and I want to make multiple files based on the values of col1 and inside each file, the tabs should be named after the values in col2. The data should correspond to the entries associated with col2 values. My current method gives this output error "Output Data (45) sheetname is an invalid Sheet/Range specification for Excel". Please help in rectifying this.

image.png

Macros

Transformation

Dynamic Processing

Accepted answers

binu_acs

@saachitalwar One way of doing this

CreateExcel_171023.yxmd

All comments

binu_acs

@saachitalwar One way of doing this

CreateExcel_171023.yxmd

SPetrie

I cant really make anything out in the image but I think you are using a UNC path.

Make sure your file name is something along the lines of \\networklocation\folderlocation\name.xlsx|||sheetname

"\\Networklocation\Folderlocation\"+[col1]+".xlsx|||"+[col2]

Make sure that when you are specifying to take the File/Table Name from field, you are changing the entire file path and removing that field from the output (if you choose to)

apathetichell

If the sagely advice of @SPetrie and @binu_acs isn't enough - post the config of your formula tool. there are a near inifinite number of things you could be doing wrong here. and some of them may invlolve the mysterious ` vs the less mysterious '

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280