Excel File Name Saving Problem with Circular Reference - this is WEIRD!

5 replies
Hi,

Excel Guru Wanted!

This is strange problem and finally isolated the problem but don't understand the end solution.

Anyway I have this big spreadsheet that has a few tabs that are 'conditionally formatted.' I'm just mentioning these 2 things as background as perhaps either is causing the problem - maybe more the later.

anyway I always usually save my file names as:
this-is-an-example-of-how-i-save-my-file names

However when saving this spreadsheet with either hyphens or underscores it comes up with an error message referring to location of the file when it should be fine!

Yet it saves fine without underscore or hyphens. Explanation please!
#circular #excel #file #problem #reference #saving #weird

Trending Topics