Can I link underlying workings to a SmartView upload file?
We are new to FCCS and a lot of our users have existing working files that they want to use as a data source to load to FCCS using SmartView. The users want to link the "yellow" input cell to the underlying working file AND RETAIN the link after the data has been uploaded?
Our workaround is to have a copy of the SmartView worksheet on a separate worksheet with all the links in place and then to copy-paste-values into the actual SmartView worksheet to load. This works but users grumble about maintaining two versions of the input sheet. Is there a smarter way to tackle this?